SSRS Date

  • Here's what i have so far. I want it to say if quarterly, then display StartDate + 3 months - 1 day. Which should give me the end date. I'm trying to populate quarterly and monthly.

    The next part should give me the last day

    =IIF(

    Parameters!ReportTimeFrame.Label = "QUARTERLY"

    ,DateAdd("m", -4, DateSerial(Year(Now()), Month(Now()), 1)) + DateAdd("m", 3, DateSerial(Year(Now()), Month(Now()), 1)) - DateAdd("d", -1, Today)

    ,DateAdd("d", -1, DateSerial(Year(Now()), Month(Now()), 1))

    )

  • kamaln63 (5/7/2015)


    Here's what i have so far. I want it to say if quarterly, then display StartDate + 3 months - 1 day. Which should give me the end date. I'm trying to populate quarterly and monthly.

    The next part should give me the last day

    =IIF(

    Parameters!ReportTimeFrame.Label = "QUARTERLY"

    ,DateAdd("m", -4, DateSerial(Year(Now()), Month(Now()), 1)) + DateAdd("m", 3, DateSerial(Year(Now()), Month(Now()), 1)) - DateAdd("d", -1, Today)

    ,DateAdd("d", -1, DateSerial(Year(Now()), Month(Now()), 1))

    )

    I think the expression is not correct you have to embed each call of the function DateAdd()

    If you want the StartDate + 3 months - 1 day

    DateAdd("d",-1,DateAdd("m",+3,StartDate))

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply