Between two Dates AND Time! Help

[pjdube]

Hi again!

Okay, I have been trying to figure out how to get certain records between two dates and times.

On the Date/Time column I have put the below criteria:

Between Date()+(7-Weekday(Date(),6)) And Date()-Weekday(Date(),6)

This works great with getting ALL the records from the last Thursday to the upcoming Thursday, which is partially what I want.

But now I am trying to figure out how to be able to ALSO get it from a certain time range.

My week ends on Thursday at 2pm, so clearly if I can grab all records from last Thursday after 2pm to this upcoming Thursday before 2pm then I can see my progress.

Yes, the entire column is Date/Time stamped (i.e. 8/13/2020 10:29:59).

Can anyone help or at least point me in the right directions so that I can figure this out?



Thanks!

Phil

[pbaldy]

A couple of thoughts. First, I've seen instances where the reverse didn't work right, so I always put the lower value first in a Between statement. You should be able to add the time:

?Date()-Weekday(Date(),6) + #14:00:00#
8/13/2020 2:00:00 PM

[pjdube]

pbaldy,

Perfect! It worked! Exactly what I wanted.

Phil

[pbaldy]

Happy to help!