Greater than 30 days old

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

Guest

I have a date field called Date1. I would like to pull back records that are
greater than 30 days old. How would that query look?

Thanks.
 
I have a date field called Date1. I would like to pull back records that are
greater than 30 days old. How would that query look?

Thanks.
Click to expand...

Where YourTable.Date1 < Date()-30

or you can use ....
Where YourTable.Date1 < DateAdd("d",-30,[Date1)
 
Are you saying that you want to use a criterion of today's date, minus 30
days, as your cutoff point?

If so, you could add a criterion in the criterion row under your [Date1]
field ... something like:

< Date()-30

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
rml said:
I have a date field called Date1. I would like to pull back records that are
greater than 30 days old. How would that query look?
Click to expand...


Set the date1 field's criteria to
 
Back
Top