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!
Solved! Go to Solution.
Use $$TODAYb-12m and $$TODAY that will give you 8/1/21 to today.
I knew it had do be something simple like that. Thank you so much 🙂