Home Forums SQL Server 2005 Business Intelligence set default value of date paramter as getdate()-1 in SSRS report RE: set default value of date paramter as getdate()-1 in SSRS report

  • April 12, 2012 at 7:15 am

    #1472557

    Try this:

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

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP