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!

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top