Setting the Date by the Time (1 Viewer)

[Jul]

I have several forms that our machine operators have to enter data into several times during their shifts. The question/suggestion was brought up as far as having the date automatically fill in based on the time they enter on their screens. However, the tricky part is we use date based on shift. Our shifts are from 6:45am-6:45am the next day, so if they enter a time between those times, the date would be today, otherwise, the date would be tomorrow. Any suggestions?????

 

[KenHigg]

So between 6:45am and midnight would make the date what ever the actual date is but a time of 12:01am and 6:45am would be what ever todays date is minus 1?

 

[KenHigg]

So between 6:45am and midnight would make the date what ever the actual date is but a time of 12:01am and 6:45am would be what ever todays date is minus 1?

 

[Jul]

That is exactly what I need! Glad you could understand what I am trying to do. Do you know how to do it?