AlexOnTheHill Posted February 22 Share Posted February 22 Hello, I have a report which returns results over the last 220 days using this variable: DATE_SUB(CURDATE(), INTERVAL 220 DAY) This works well but I would like to run the same report for the 220 days prior to that. I thought I could use: DATE_SUB(CURDATE() - 220, INTERVAL 220 DAY) but it doesn't seem to work. Is that the right way to do this or is it not achievable? Many thanks Link to comment Share on other sites More sharing options...
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 account
Already have an account? Sign in here.Sign In Now