what does this mean?

[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

 

[John Spencer]

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
..

 

[Guest]

Thanks, John for such a quick response and answer to my question.

 

[Kathy]

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.

 

[Michel Walsh]

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

 

[Kathy]

Thank you so much. I sometimes have a tendency to see things backwards.