Search code examples
ssrs-2008reporting-services

Excluding the time in a "date/time" parameter for SSRS reports

In my SSRS report, I wanted to allow the users to specify a date (that would be used to filter the data on a report). When I did this, the parameter also includes the time. Is it possible to just allow the user to select a date, without showing the time? Can I also give it a default value of the current date?

The steps that I had already applied to the report parameter:

  1. Set the parameter to "date / time" data type.
  2. Set the default value of this parameter to be =Now.

When I did this, the report parameter would show me:

23/04/2013 00:31:22
Solution

  • Instead of using =Now() you can use =Today() which provides current date without time .If you are getting data from DB then you can 

    =Format(Fields!YourDateColumn.Value,"dd/MM/yyyy")

    Check this MSDN article for using expressions and formatting the date time column