Date range for a report

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

Hi

I am trying to run a query and can't seem to nail down the right code.
We use the access database to track files, incoming/outgoing correspondence
dates etc.
I am trying to run a query that show me files with dates in a follow up
field of -60 days to +7 days, so essentially any follow ups missed in the
last 2 months and up coming in the next week.
This report is run on a weekly basis.

Appreciate any help

Thanks
 
Assuming that the follow up field is actually a date/time data type, try this
in the criteria:

Between Date() - 60 and Date() + 7
 
Hi

I am trying to run a query and can't seem to nail down the right code.
We use the access database to track files, incoming/outgoing correspondence
dates etc.
I am trying to run a query that show me files with dates in a follow up
field of -60 days to +7 days, so essentially any follow ups missed in the
last 2 months and up coming in the next week.
This report is run on a weekly basis.

Appreciate any help

Thanks
Click to expand...
= DateAdd("d", -60, Date()) AND < DateAdd("d", 8, Date())
Click to expand...

will work (even if the datefield contains a time portion, hence the 8)
 
Back
Top