I have code that pulls any request where the date of the request is between 5-30 days old from today's date:
AND (DAYS (CURRENT DATE) - Days (REQ.DT) BETWEEN 5 AND 30)
Now the group wants to change it to pull >4 and a rolling 12 months starting with the 1st date of the current month.
So if today is 11/20/15 then I would need to pull requests from 11/1/2014 - 11/15/2015
How can I do this without updating the code manually each time it is run?