Date Calculations

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

Guest

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?
 
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
 
Back
Top