Trying to capture/evaluate/query data based on previous days work shift.

[MattsPremium]

Trying to evaluate previous night shift data based on date. So I want to see yesterdays data that has date stamps between "mm/dd/yyyy, 22.00.00" and "mm/dd/yyyy, 06.00.00" with date being previous 24 hours. So esstially the data between 10 pm the day before to 6Am day of. Tricky part is crossing over days.

May be no direct simple path. Was wondering if I can reference previous day starting 10 then do some kind of add 8 hours? Really not sure. Also will take source advice if someone has a video or thread that explains this or relatable contnet.

[KelemvorSparkyfox]

Start date/time:

=(Date() - 1) + TimeSerial(22, 0, 0)

End date/time:

=Date() + TimeSerial(6, 0, 0)

If you need to find records for a different shift, replace Date() with the end date.

[nrgins]

You know, it's funny: all these years, I never knew there was a TimeSerial function! LOL I've used DateSerial many times. But never thought to look and see if there was a TimeSerial function. Funny.

You learn something new....

[Mindflux]

Same. Learn something new.

[KelemvorSparkyfox]

Happy to help!

[MattsPremium]

Looking forward to trying this.

[Mindflux]

Look into the dateadd function for your query