Default parameters in expressions

• Dan McGorty

  SSC Journeyman

  Points: 84

  More actions

  March 28, 2005 at 9:57 am

  #163871

  Hi. I'm a stark newbie to Reporting Services. Having trouble using a default parameter in an expression. I'd like to set the default parameter in a date field to date()-1 for yesterday's date but can't seem to get it to work. Tried it both in VS and in the Report Manager interface - no luck. Any help will be much appreciated.

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  March 28, 2005 at 9:58 pm

  #549249

  =DateAdd(Dateinterval.Day, -1, Today())