Reporting with the curdate() variable

[AlexOnTheHill]

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]

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]

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]

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]

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