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

Question

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

Answer 1

Depends on type of IDE you use, you may NOT be able to use some of those suggested methods. This always work for me: Set parameter type=TEXT instead of Date/Time, then on query convert your date as follow: SELECT Value=Convert(varchar(20),payperiod,101)

Answer 2

I hope this helps. My way of accomplishing this is:

=DateSerial(Year(Now), Month(Now), Day(Now))

Thank You,

Answer 3

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