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

Using Date Wildcard on Report


Level 2

I am trying to filter report to show "Current Year" of billing records between beginning of current year and previous month of current year. I'm using Date: $$TODAYby between $$TODAYe-1m. The report is still showing January 2022 billing record data. It seems like January is throwing off the filter since there isn't a previous month in the current year. Does anyone know of a way to resolve this? I have many reports and don't want to manually change them to fix the problem.


Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply


Level 10

HI @Stephanie Hetzel‚

May be possible to try: $$TODAYb-1m and $$TODAY