Date issue please help

[ThaiByThai]

how can I set the Date function for user to enter a date to generate the data?

i have a make-table query - and in that query each day we have to change the date (, #3/4/2011# AS CAP_DATE) to yesterday date

is there a way we can have the query or set it to read yesterday date? and if it's Monday ready Friday's date?

thank you for all your help!

 

[Brianwarnock]

How about

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

This assumes that you are using the default of Sunday being day 1

Brian

 

[ThaiByThai]

Thanks a bunch! going to test it out now