Yesterday's Date ignoring weekends

[coletteabrown]

Hello -

I'm using the Date()-1 to populate a form with yesterday's date for easier data entry. However, on Mondays I always have to change the date to Friday's date because it is populating yesterday's date (which in this case is Sunday). Is there an access expression that calculate yesterday's date but ignores weekends? So that on Monday yesterday would mean Friday?

Thanks!


Colette

[Bob Fitz]

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

[coletteabrown]

That worked! Thanks

[Bob Fitz]

That worked! Thanks

I never doubted that it would , but it would need some modification to handle entries made on a Sunday as well.

[coletteabrown]

Haha!

Not to worry, I'll stick to running Friday's reports on Monday. Thanks