chriscorcoran Posted January 30, 2017 Share Posted January 30, 2017 Hi I'm trying to pull a report that shows all requests that have not been updated in the last 14 days. I'm using the following custom query but its returning further back than I want. DATE_SUB(NOW(), INTERVAL 14 DAY) Anybody else done anything similar, or know what query I should run? Attached is the screen shot from the report. Thanks Chris Link to comment Share on other sites More sharing options...
Kelvin Posted January 30, 2017 Share Posted January 30, 2017 @chriscorcoranI have used the following on various widgets DATE(NOW() - INTERVAL 14 DAY) Link to comment Share on other sites More sharing options...
chriscorcoran Posted January 30, 2017 Author Share Posted January 30, 2017 Thanks Kelvin Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now