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

  • March 10, 2016 at 11:16 am

    #1864327

    rcooper 78099 (3/10/2016)

    so in SSRS what if I wanted the date to always be tomorrows date?

    You should be able to come up with that yourself.

    This is the calculation to find "yesterday":

    =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