We help IT Professionals succeed at work.

date range between todays date and a date 6 months form today

HOTWATT
HOTWATT asked
on
I have a query and I am trying to use criteria under the field RQ_DATE_REQ to narrow a query down to a date range between the current date and 6 months from the current date. Should I be using date diff
 
 Any help would be appreciated!
Comment
Watch Question

Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
You could use:

Between Date() And DateAdd("m",-6,Date())

Open in new window

/gustav
Top Expert 2014
Commented:
Where RQ_DATE_REQ Between Date And DateAdd("m", 6, Date)

Open in new window

Author

Commented:
Thanks for the help that worked!