Expand my Community achievements bar.

Check out the upcoming December events for Workfront System Administrators!

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