Date Criteria - no older than 30 days

[Bob Watson]

If you have a field named "Date" how do
you phrase a criteria to get records no older
than 30 days??

[date]=> (today-30) ????


TIA,
Bob

 

[Jackie L]

First,
It is not a good idea to name a field "Date" since that is a function also.

Either way, are you putting this criteria in a query? If so, you can use
the following on the criteria line of your "Date" field:

=Date()-30

If you would like to restrict it based on a different increment than days,
check the Microsoft knowledgebase for "Functions for Calculating and
Displaying Date/Time Values"

Hope this helps.

If you have a field named "Date" how do
you phrase a criteria to get records no older
than 30 days??

[date]=> (today-30) ????


TIA,
Bob

 

[Bob Watson]

Thank you ... I agree with you, I would never
name a field DATE or TIME or Lots-of-other-things
that sound like a function. I got into this
game late.

First,
It is not a good idea to name a field "Date" since that is a function
also.

Either way, are you putting this criteria in a query? If so, you can use
the following on the criteria line of your "Date" field:

=Date()-30

If you would like to restrict it based on a different increment than days,
check the Microsoft knowledgebase for "Functions for Calculating and
Displaying Date/Time Values"

Hope this helps.

If you have a field named "Date" how do
you phrase a criteria to get records no older
than 30 days??

[date]=> (today-30) ????


TIA,
Bob