Yesterdays date

[Sunny Girl]

Hi

I'm trying to use the date function in an access 2000 query to display data
for only yesterdays date, that works ok using date()-1 but how do I cope
with the weekend? On Monday I want to pick up Friday's data not Sundays.

The data comes in the format yyyymmdd and I'm converting it to dd/mm/yyyy.
Would it be any easier to use it in its direct form for this?

Thanks in advance.

Ruth

 

[Roger Carlson]

Try this:
Expr1: IIf(Weekday(Date())=2,Date()-3,Date()-1)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Hi Ruth, Use the following in your query in place of the date()-1

IIf(Weekday(Date())=2,Date()-3,Date()-1)

 

[Sunny Girl]

Thanks Guys, that looks great.

Ruth