You need to sign in to do that
Don't have an account?
KIBL
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?
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
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?