Date Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Terry said:
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.
Click to expand...


Just use the criteria:

< DateAdd("m", -1, Date())
 
Field: someDateField
Criteria: < DateAdd("m",-1,Date())


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top