Date range for a report

[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

 

[Jerry Whittle]

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

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

 

[John W. Vinson]

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

= DateAdd("d", -60, Date()) AND < DateAdd("d", 8, Date())

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

 

[Tracey]

Thanks guys!
Happy New Year!

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