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

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

  • August 23, 2022
  • 1 reply
  • 653 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Stacey_Robertson

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

1 reply

S
Stacey_RobertsonAccepted solution
Level 5
August 23, 2022

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

    K
    Kasey-GagneAuthor
    Level 5
    August 24, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...