Dates and Times

[kjbrack]

I am wanting to pull all records with the criteria for the Day field to show all records from yesterday at 7:00 am till today at 3:00 am.

Day field is a date/time format, Table name is Barrel Production .

Here is what I have tried with no luck:

Between date()-1, 07:00:00 and date ()+1, 03:00:00


:banghead::banghead::banghead::banghead:

 

[arnelgp]

Between ((date() -1)+#7:00 am#) And ((date() +1)+#3:00 am#)

 

[kjbrack]

That worked, Thanks

 

[arnelgp]

Glad to hear that.