function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Report Duration

I need a way to have my report have a duration of '4 month rolling starting with the current month'. In April, I want to see 4/1/10 to 7/31/10. Do you know of any way to achieve this? There is no standard duration that works for me. I tried to use a filter of EOD = This Month and EOD = Next 1 Quarter but that I don’t believe would roll correctly. It looks like it works for March but then in April it would give me April, July, August, and Sept.

Any thoughts?

Your problem can be solved by using the date field in question say "TestDate" in the filter criterion and use the following:-

TestDate equals NEXT 120 DAYS 

Set Field = TestDate, Operator= Equals and Value= NEXT 120 DAYS

Unforatunately, this will not get me what I am looking for.   If I set this today, I will be missing the first 26 days of March and only get a portion of July.  I need All of March and all of April, May, and June.

Bump, I'm dealing with the same issue.  I need to essentially say "2 Months Ago" and capture the full month.  So if we're at April 7th, the report date should dynamically populate to Feb 1 - Feb 28.


Any ideas?