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