ssrs 2008 today and yesterday as parameter values

  • In an SSRS 2008 r2 report, I want to set the default value to yesterday's date in a parameter called startdate. In a parameter called enddate, I want to set the default parameter value to todays date.

    I have tried the following to set the default values:

    =today()

    and

    =DateAdd("d".-1.today()).

    The above does not work.

    Thus would you let me know how to set the default parameter values of start date to yesterday's date and the enddate to today's date?

  • found answer

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

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