dateadd function

[timeh]

hi, i'm writing a query for a mailmerge which i want to be produced when the date is a week before a date already set in a date field.
i.e. Field name = Date
Criteria = ?

I think it has something to do with the dateadd function, but i'm not sure exactly how to do it

any help is much appreciated

Thanks in advance, tim

 

[raskew]

Date is a reserved word and it would be wise not to use it as a field name.

You won't need the DateAdd() function--simple subtraction will do the job.

Here's an example in the debug window (Cntl-G):

MyDate = date()-7
? MyDate
12/14/02