Rolling Last Month to align with Rolling This Month (excluding today) | Community
Skip to main content
nataliek8926704
New Participant
Nov 10, 2021 8:24 PM UTC
Solved

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

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
yuhuisg
yuhuisgAccepted solution
New Participant
Nov 12, 2021 4:04 PM UTC

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.

View reply

3 replies

yuhuisg
yuhuisg
New Participant
Nov 11, 2021 4:00 PM UTC

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

Translate
nataliek8926704Author
New Participant
Nov 11, 2021 4:10 PM UTC

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. 

Translate
yuhuisg
yuhuisgAccepted solution
New Participant
Nov 12, 2021 4:04 PM UTC

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.

Translate
Terms & ConditionsAccessibility statement

Loading footer...