Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a calendar where the day starts at 6:30PM and ends 6:29PM the next day.
For example, when I select 6/30/2014, then this selection corresponds to records from 6/29/2014 6:30PM to 6/30/2014 6:29PM.
Thanks.
Use the DayStart function:
From the help file:
daystart ('2006-01-25 16:45', 0, 0.5 ) returns '2006-01-25 12:00:00' with an underlying numeric value corresponding to '2006-01-25 12:00:00.000'
In your case you will want to set the offset to 18.5/24 instead of 0.5