I do weekly and month to date reports in ReportBuilder using rolling dates. The month to date rolling start date is "cm" so that we can start at the beginning of the month. The issue is after the last week of the month, in other words during the first week of the following month, "cm" ends up pointing to the beginning of the following month. This messes up the end of month reporting and requires either a set up to refer to dates in the spreadsheet, a manual changes of the requests, or a seperate report just for the end of the month.
It would be great if there was a conditional aspect to the rolling dates so if run day of month is less than 7 (when I would run the end of month report), then it should start "cm-1m."