Solved

How to control the Time Slots?

Posted on 2008-06-19
4
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 500 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
 
LVL 63

Expert Comment

by:SysExpert
ID: 21827745
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 21827754
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

Independent Software Vendors: 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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Suggested Courses

752 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