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

enter image description hereDepends 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)


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