Pull Out within 30 days of a today's date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sally t - 11 Nov 2005 08:17 GMT

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

Reply to this Message

Allen Browne - 11 Nov 2005 08:50 GMT

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)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 6 lines]
> DateDiff
> - any clues? Many, many thanks Sally T

Reply to this Message

sally t - 11 Nov 2005 12:46 GMT

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

> 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:
[quoted text clipped - 10 lines]
> > DateDiff
> > - any clues? Many, many thanks Sally T

Reply to this Message