If the "date" is in a text field, you need to convert it to a date first.
This can be a problem if someone types in something like 13/13/2006. So first
we need to test for the ability of Access to evaluate it as a date; convert
it to a date if so; deal with it if not a valid date. Put the following IIf
statement in the heading of a query and change "YourTextField" in both places
to the actual field name.
Actually, I meant 60 days ago thru the present. (sorry)
Can't seem to get either of your suggestions to work (no data is returned).
If I enter > "20060430" in the criteria, it works. Of course, I don't want
to have to change the query each day, so I would like to use (current date -
60) - somehow.