AlexOnTheHill Posted February 22, 2023 Posted February 22, 2023 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
Steve Giller Posted February 22, 2023 Posted February 22, 2023 You could try with: DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 220 DAY), INTERVAL 220 DAY) but I can't be sure that would work, I'm not sure how happy SQL is with nested functions. Also, depending on the WHERE clause, that may just return the last 440 days. Update: BETWEEN DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 220 DAY), INTERVAL 220 DAY)AND DATE_SUB(CURDATE(), INTERVAL 220 DAY) would be from -440 days to -220 days, I believe, but do get someone more familiar with SQL to check first.
AlexOnTheHill Posted February 23, 2023 Author Posted February 23, 2023 We are trying to test this today but we are unable to make any changes to any reports. If I make a change the save icon is greyed out, not just for myself but for colleagues also.
Steve Giller Posted February 23, 2023 Posted February 23, 2023 We're aware of an issue that prevents the Save button from activating when changes are made. I'll update this thread when we have further details.
AlexOnTheHill Posted February 27, 2023 Author Posted February 27, 2023 I can confirm with the new release (Core UI 1844) and the patch that was applied to our instance on Friday we are no longer experiencing this issue
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