Post reply

Max Date - 1 day

  • June 13, 2014 at 7:56 am

    #308086

    Using SSRS I'm trying to use the max date minus 1 day in the title ....Max(Fields!DateName.Value, "DataSet1")

    BTW: I've tried DateAdd(DD, -1, Max(Fields!DateName.Value, "DataSet1")

    Thanks

    Joe

  • June 13, 2014 at 8:24 am

    #1721495

    Turns out I did that same thing when I first tried it... You have to wrap the units in double quotes, because this is .NET, not SQL (so the rules are slightly different):

    =DateAdd("d",-1,MAX(Fields!TransDate.Value, "BankBalance"))

  • June 13, 2014 at 1:25 pm

    #1721649

    Thanks worked great !!

  • June 13, 2014 at 5:12 pm

    #1721684

    Good to hear!

    You're welcome =)

Viewing 4 posts - 1 through 3 (of 3 total)

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