Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

nataliek8926704
Level 1
Level 1

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? 

3 Replies
yuhuisg
Community Advisor
Community Advisor

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

nataliek8926704
Level 1
Level 1

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
Community Advisor
Community Advisor

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.