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

[Guest]

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

 

[Maxence HUBICHE]

Hello Sal,
Try :
DateAdd("d",-7,Date())



===================
Maxence HUBICHE

MVP Access
Revendeur CaseStudio (http://www.casestudio.fr)
Responsable Access sur http://www.developpez.com