Instead of saying:

{Last Rcpt Date} < DATE(2014,04,01)

how can I say:

{Last Rcpt Date} < 2 years

or:

{Last Rcpt Date} < 6 months

Hi Susan

What I would do is to create a formula called "Cutoff Date" like this:

QUERYDATE("Enter the Cutoff Date")

which will prompt for a date whenever you refresh the report, and then use this formula in the filter:

{Last Rcpt Date} < {Cutoff Date}

Steve

Using Today()- 730 or Today()-182 works if close is OK, otherwise more involved date calculations will be needed.

You can combine Steve and Michael's suggestions to:

Thanks, Michael's answer is exactly what I needed!