date testing

[kabir_hussein]

Hi

This may be easy but i have had a look at the Access help page and can not find any suggestions to my question

i am trying to do a query where i want the query to check for any changes in the last 30 days

Access Help expressions
Between #2/2/93# And #12/1/93#

this is the help i have found to do date query. however i wanted a expression where i dont have to change the expression every 30 days.

my date format is day/month/year

many thanks

 

[ColinEssex]

Between Date() and DateAdd("d", - 30, Date())

Col

 

[kabir_hussein]

many thanks works a treat