set SSRS date parameter default value to previous date(getdate()-1

• sql_ques

  SSCommitted

  Points: 1546

  More actions

  April 12, 2012 at 4:59 am

  #254666

  Hi,

  What is the expression to set the default date of date parameter to getdate()-1. I want the SSRS report to choose the Startdate as previous date and end date as current date.

  I set the default value of parameter as =Today(), which displays current date, how to set it to previous date? Any ideas what should be the expression?

  Thanks

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  April 12, 2012 at 5:36 am

  #1472492

  =Dateadd("d",-1,Today())

• LaDBAinTx

  Valued Member

  Points: 55

  More actions

  January 31, 2013 at 1:28 pm

  #1583158

  Thanks Howard!