Post reply

using parameter date - 21 days in field header?

  • February 15, 2013 at 11:54 am

    #268660

    Looking to use a parameter filed -21 days for a field header in MM/YY format?

    Thanks

  • March 5, 2013 at 5:28 pm

    #1593697

    You can refer to parameter values in the report using an expression like this:

    =Parameters!Parametername.value

    If the parameter is a date datatype, you can use the dateadd function

    =dateadd(DateInterval.Day,-21,Parameters!Parametername.value)

    Then write this into the format property for the text box

    MM/yy

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

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