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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date/Text field in Report 7
Display weeks from a Milestone 0
How to show day of week 4
Change Data Format 2
Format as date 5
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
How to change date format to 7 working days a week in ms project 2010? 0
query sql needed 3

Top