How to say in reporting filter 'Last 12 months' | Community
Skip to main content
J
JustynaPa
Level 2
February 22, 2024
Question

How to say in reporting filter 'Last 12 months'

  • February 22, 2024
  • 2 replies
  • 666 views

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
February 22, 2024

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

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    February 22, 2024

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...