Date Calculations

K

Kissi

I have a shipdate field and want to run a query on dates that are 30 days or
more from shipdate to today's date. Can anyone help?
 
O

Ofer Cohen

Under the field shipdate enter the criteria

<Date()-30

Or,
<DateAdd("d",-30,Date())

To return all the records that are older then 30 days or more from current
date
 
Top