You’re offline. This is a read only version of the page.
14
Hi
Im wanting to filter the records in a collection based on a set date and time value. Currently our "shifts" run 0600-0600(24hrs).
Im trying to use an If statement based on user Date/Time
If user time is after 0600 im thinking/tried using something along the lines of Today() & StartTime > 06:00
However Im getting stuck if some one views it past midnight but is still in "the shift" as obviously the Today() Value changes and is out side current shift
In the records the date is formatted as dd/mm/yyyy and Start time values as text "06:00"(24hr time)
Cheers
Share
Report
All responses (
Answers (
