DATE Question
 

Hi, I have a file in which I have an order date column, the date is in the
form of MM/DD/YYYY, what i am trying to do is to find all files More then a
month old from the current date. ie ( Todays date 10/11/2007) - 1 Month) and
then give a list of files which fit the criteria.

Thanks in advance for your help.

DATE Question
 

Measuring in months always raises questions. What would you think the
**date** that is one month before October 31, 2007? How about March 31,
2007?

Rick


"Terry" wrote in message
...
Hi, I have a file in which I have an order date column, the date is in the
form of MM/DD/YYYY, what i am trying to do is to find all files More then
a
month old from the current date. ie ( Todays date 10/11/2007) - 1 Month)
and
then give a list of files which fit the criteria.

Thanks in advance for your help.