Thursday, 29 October 2015

SSRS Parameter Displays Date and Time


Another trick and tip to my blog!


If you want to show the parameters with data and time option both below is a quick way to do it.



Normally date/time parameters only display the date however if you add below expression now() then the parameter value shows current date and time.


If you want one date/time parameter to show a day before current date then use DateAdd option as below.

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


When you run the report final result will look like below.