Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to control the Time Slots?

Posted on 2008-06-19
4
Medium Priority
?
244 Views
Last Modified: 2013-12-18
I'm working on an application used for booking Transport cabs, since we work in shifts; employees use the transport facility as per the shift schedule. The shift schedule as well as the transport schedule is prepared for a fortnight. To manage the transport system efficiently we have a policy that user should not select a time slot within 12 hour window for pickup and should not pick a drop slot with in 1 hour window. I have created a form to program the slots like 7:00, 11:30, 15:45, and 17:45 etc. User has option to select the predefined slots from the master form. Im using @dbcolumn formula to select the slots from a view.
Now what I want to program is when user tries to change the pickup slot lets say around 7:00 in the morning, he should only see the slots available on or after 19:00 similarly if it he tries to change the drop slot at 7:00 he should able to select any slot after 8:00. Pls help in developing this functionality.

Thanks
0
Comment
Question by:Prashantbhatnagar
  • 3
4 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 1500 total points
ID: 21827734
You need to select with a date value, so that the difference is > 12 hours, in your select formula.
All time slots should be set as full dates, so that you can use Date math to figure out > 12 hours.

I hope this helps !
0
 

Author Comment

by:Prashantbhatnagar
ID: 21828839
The problem is the time slots I have put are 7:00, 9:00, 11:30, 15:45, 17:45, 20:45, 23:30, 00:30 - Now when I compare using SELECT Form = "Pickup Slots" &@TextToTime(PickupS)>@Adjust(@Now;0;0;0;12;0;0) it does not work. The when the user try to change the slot at any point of the day the slot which are within 12 hours should be hidden.
One crude method which I can think of is storing the time slots in different views and calling the views in the combobox depending on the time of the day.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question