Formula for specific date range

R

R Monroe

Hi! I have a report with a column of dates (Date X). I need to filter the
report to show only those records whose Date X falls within -225 and -135
days from today's date. We cannot figure out how to write the formula. Any
help is appreciated!
 
F

fredg

Hi! I have a report with a column of dates (Date X). I need to filter the
report to show only those records whose Date X falls within -225 and -135
days from today's date. We cannot figure out how to write the formula. Any
help is appreciated!
Click to expand...

Does this work for you?
As criteria on the [DateField] column in the query:

Between DateAdd("d",-225,Date()) and DateAdd("d",-135,Date())
 
Top