I'm trying to figure out how to create a rolling date-range to compare MoM data. For example, looking at this month excluding today, Nov 1 - Nov 9. I would like to be able to compare it to last month, same timeframe: Oct 1 - Oct 9. I tried to create a date range to accomplish this (Start: Start of current month minus 1 month End: End of current day minus 1 month) but it doesn't work and is populating as Oct 1 - Sept. 30. Is there any way to accomplish MoM comparisons for this month (excluding today) compared to the same timeframe in the previous month?
There's a formula in excel that accounts for that, was hoping it would be similar in Adobe. If that's not possible, at day 30 or 31 (28 or 29) I would just look at full MoM data and ensure the report is not scheduled to send.
Well, I think it's safe to say that AA does not have the equivalent of that Excel formula.
So your suggested solution about using MoM data looks like your next best option.