Trying to get a date which is 7 days prior to the current date

S

Sal

Hi,
I have a labor database in which there is a calendar form picking the
current date. I also want to get the date for the prior week too. i.e. This
week is 2/23/2005 I want to get last weeks date 02/16/2005. This is used to
report only the transactions since the last report. I tried various DateDiff
functions and I can't get my results.

Any suggestions?
Thanks
 
Top