Pull Out within 30 days of a today's date

[Guest]

Hi, I'm trying to do a query that will look at today's date =date() and
compare with a date stored in a table and pull out if they are within 30 days
of each other - either before or after! Is that possible? I can get the no
of days calculated and the difference in days DateDiff but I cannot then pull
out Between And because Criteria won't work on the calculated field DateDiff
- any clues? Many, many thanks Sally T

 

[Allen Browne]

If you want to select the records for 30 days back and 30 days forward, try
this in the Criteria row of a query under your date/time field:
Between (Date() - 30) And (Date() + 30)

 

[Guest]

Fantastic - that's perfect! Thank you very much Allen.
Sally