Rolling Last Month to align with Rolling This Month (excluding today)

[nataliek8926704]

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? 

[yuhuisg]

How were you planning to handle the situation where the current month and previous month have different number of days?

[nataliek8926704]

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. 

[yuhuisg · Accepted solution]

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.