Howto display records with dates less than a date from a prompt?

[bytes access nubie]

When a query is run, i want a prompt displayed allowing the user to enter < DATE to find all records less than the specific date. e.g. < 1/1/2011.

I know how to do that with a start date AND end date (Between [Enter Beginning Date] And [Enter End Date]) in the criteria field, but that's not what I'm looking for.

A small number of users with modify the Last Reviewed date field every 2 months to confirm that they've reviewed their data. I will want to be able to check for records where the Last Reviewed date has not been changed in the last 3 weeks or so of running the query. I will then follow up with those users....

[jimatqsi]

Instead of Between you will simply use <
So <[Enter Cutoff Date] or whatever wording you want to use in the brackets.

Jim

[bytes access nubie]

That works, thank you!! So, it seems it is not possible to use the greater than or less than symbol in the prompt window? thank you very much!