Monday, November 26, 2012

SSRS: Quarter Filter Expression where May is the first month of Fiscal Year

StartDate=CDate(iif(Parameters!Quarter.Value=1,"5/1/"&Parameters!Year.Value-1, iif(Parameters!Quarter.Value=2,"8/1/"&Parameters!Year.Value-1, iif(Parameters!Quarter.Value=3,"11/1/"&Parameters!Year.Value-1, "2/1/"&Parameters!Year.Value))))


EndDate=CDate(iif(Parameters!Quarter.Value=1,"7/31/"&Parameters!Year.Value-1, iif(Parameters!Quarter.Value=2,"10/31/"&Parameters!Year.Value-1, iif(Parameters!Quarter.Value=3,"1/31/"&Parameters!Year.Value, "4/30/"&Parameters!Year.Value))))

No comments:

Post a Comment