Skip to main content
JustynaPa
Level 2
Feb 22, 2024 5:43 PM UTC
Question

How to say in reporting filter 'Last 12 months'

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

J_Mas
J_Mas
Level 5
Feb 22, 2024 7:20 PM UTC

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:

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

actualCompletionDate=$$TODAY-12m
actualCompletionDate_Mod=gte

Translate
    skyehansen
    Adobe Champion and Community Advisor
    skyehansenAdobe Champion and Community Advisor
    Feb 22, 2024 7:37 PM UTC

    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...