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
Solved

How to control the Time Slots?

Posted on 2008-06-19
4
231 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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