Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Using Date Wildcard on Report

Avatar

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

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

1 Reply

Avatar

Level 10

HI @Stephanie Hetzel‚

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

Mvh

Kundan