MS Access and Date

[Duane Riech]

I have a MS Access table which contains a Date tag on each record.
I want to retrieve records based on:
Today - 1 month
or
Today - 2 weeks
etc.
Can anyone tell me the syntax?
Thanks

[Sam Moran]

I am assuming you want SYSDATE (minus) a number of days. If so, have you tried the following:
SYSDATE - 6?
I hope this helps.

[Mathias Nilsson]

SELECT * FROM MyTable WHERE MyDate BETWEEN Now() AND DateAdd("d", -6, Now())