Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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.