How do I modify "past year" dates to start at the beginning of the month? | Community
Skip to main content
Kasey-Gagne
Level 5
Aug 23, 2022 8:48 PM UTC
Solved

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

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.
Stacey_RobertsonAccepted solution
Level 5
Aug 23, 2022 9:29 PM UTC

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

View reply

2 replies

Stacey_RobertsonAccepted solution
Level 5
Aug 23, 2022 9:29 PM UTC

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

Translate
    Kasey-GagneAuthor
    Level 5
    Aug 24, 2022 2:41 PM UTC

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

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...