I'm trying to create an input box that asks the user to input a date. I want
to use that input date for a filter. I can make the input box and enter the
date, however, what the filter reads is the name of the box, not the data
that's input into it. (For example, I said AgingDate = InputBox (InputTitle,
InputMsg) and when I looked at the filter after the macro ran, the filter had
"AgingDate" instead of the actual input date)

Preferably, I want to use the input date minus 60 days as my filter
criteria, if that can be done. So if 3/9/07 was entered, the filter would say
<= 1/8/07.

What am I doing wrong?

Thanks for the help,

Chris