Expand my Community achievements bar.

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