Formula for specific date range

  • Thread starter Thread starter R Monroe
  • Start date Start date
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!
 
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())
 
Back
Top