How do I modify "past year" dates to start at the beginning of the month? | Adobe Higher Education
Skip to main content
K
Kasey-Gagne
Level 5
August 23, 2022
Beantwortet

How do I modify "past year" dates to start at the beginning of the month?

  • August 23, 2022
  • 1 Antwort
  • 653 Ansichten

I am trying to pull a report that is pulling data for the "Past Year". The filters are currently Entry Date Between $$TODAY-1y and $$TODAY but am hoping to have the "$$TODAY-1y" start at the beginning of the month vs. exactly 1 year from today so that we can compare total numbers between August 2022 and August 2021. Any help is appreciated 🙂 Thank you!

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von Stacey_Robertson

Use $$TODAYb-12m and $$TODAY that will give you 8/1/21 to today.

1 Antwort

S
Stacey_RobertsonAntwort
Level 5
August 23, 2022

Use $$TODAYb-12m and $$TODAY that will give you 8/1/21 to today.

    K
    Kasey-GagneAutor
    Level 5
    August 24, 2022

    I knew it had do be something simple like that. Thank you so much 🙂

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...