Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 1

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 4

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 4

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

Avatar

Level 1

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