Date in Query (2003)

Topic

New Reply

Hi,

I have a field call ProcessDate and I would like to build a query to show all the data those >5 days from ‘ProcessDate’ compare today.

I don’t what should I put in the criteria of the query to get what I want.

Please help.

Thanks

Regards

Reply | Quote

Replies

If you want to select records whose ProcessDate is more than 5 days before today, use the following expression in the Criteria line:

<Date()-5

If you want to select records whose ProcessDate is more than 5 days after today, use

>Date()+5

You can simply subtract or add 5 because Access calculates dates with 1 day as unit.

Reply | Quote

It works.

Thanks, Hans.

Reply | Quote