Rolling Last Month to align with Rolling This Month (excluding today) | Adobe Higher Education
Skip to main content
N
nataliek8926704
November 10, 2021
Respondido

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

  • November 10, 2021
  • 1 resposta
  • 969 Visualizações

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? 

Este tópico foi fechado para respostas.
Melhor resposta por yuhuisg

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.

1 Resposta

yuhuisg
Community Advisor
yuhuisgCommunity Advisor
Community Advisor
November 11, 2021

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

N
nataliek8926704Autor
November 11, 2021

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
yuhuisgCommunity AdvisorResposta
Community Advisor
November 12, 2021

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.

Termos e condiçõesAccessibility statement

Loading footer...