Greater than 30 days old

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

 

[fredg]

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.

Where YourTable.Date1 < Date()-30

or you can use ....
Where YourTable.Date1 < DateAdd("d",-30,[Date1)

 

[Jeff Boyce]

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

 

[Marshall Barton]

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?

Set the date1 field's criteria to