getting query to output < today()-1

[AT76]

Hi,

I have a query in access and I'm trying to figure out under criteria what is the correct syntax to obtain all dates less than yesterdays date.... < today()-1

Thanks!

 

[Eupher]

AT76,

Try: < Date() - 1

HTH,

Ken S.

 

[AT76]

Thanks Ken... I forgot to mention that the date field is in format: YYYYMMDD. Could you advice what the correct formatted way is.

Thanks.

 

[AT76]

I figured it out:

<Format(Date(),"yyyymmdd")

Thanks!