Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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 7

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 7

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