Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

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

Avatar

Level 3

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!

1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 6

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

Avatar

Level 3

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