how to offset calendar by 6 hours

[mattheomx]

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.

[Gysbert_Wassenaar]

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