+ Start a Discussion
KIBLKIBL 

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?
Ispita_NavatarIspita_Navatar

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

KIBLKIBL
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.
MLamb2005MLamb2005

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?