Queries filter?

  • Thread starter Thread starter Hjettis
  • Start date Start date
H

Hjettis

I wanted to sort out all yesterday date, and not show the time from this
records in a queries? Yesterday = 17:03:2004

16.03.2004 12:00:00
16.03.2004 13:00:00
16.03.2004 14:00:00
16.03.2004 15:00:00
16.03.2004 16:00:00
16.03.2004 17:00:00
16.03.2004 18:00:00
16.03.2004 19:00:00
16.03.2004 20:00:00
16.03.2004 21:00:00
16.03.2004 22:00:00
16.03.2004 23:00:00
17.03.2004
17.03.2004 01:00:00
17.03.2004 02:00:00
17.03.2004 03:00:00
17.03.2004 04:00:00
 
Hi,



WHERE DateValue( DateTimeField) = CDate("17.03.2004")


or


WHERE DateValue(DateTimeField) = Date( ) - 1



will return the records with a date as yesterday, any time in the day.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top