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!

How to say in reporting filter 'Last 12 months'

Avatar

Level 3

Hi guys,

Can anyone please tell me what to type in reporting filters to get a dynamic rule to show data from the last 12 months (not the last year)?

Thanks!

Justyna

2 Replies

Avatar

Level 5

It would depend on what date you're looking at (e.g. Actual Completion Date, Planned Completion Date, etc.) but here's an example of filtering tasks where the Actual Completion Date is >= 12 months ago:

Actual Completion Date gteActual Completion Date gte

If you were looking at Text Mode, the code would look like this:

actualCompletionDate=$$TODAY-12m
actualCompletionDate_Mod=gte

Avatar

Community Advisor

Most date fields in a filter will give you 3 options: this year, past year, and last year. "Past year" is the choice for if you want the last 12 months.