what does this mean?

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

Guest

I have a query with this criteria on a data field. <= Date()-4383
I know it's restricting the date but can you explain the formula please?

Thanks,
Trentrongg
 
It means that the date in the data field must be on or before today's date
minus 4,383 days. - which is 10/24/1995 (October 24, 1995 - 12 years ago).



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I have a query that I need to limit the dates from now minus 5 years. The
field is a Date/time with a format short date. I have entered into the
criteria <=Date()-1826 however it has no effect on my selections.
 
If you have nothing older than 1826 days before now, then no record would be
kept; else, only the records having a value for a data occurring before
today less 1826 days will be kept. If you want keep only the recent records,
use >= Date()-1826 instead of <=Date()-1826.

Vanderghast, Access MVP
 
Back
Top