Reporting Services Remove Time from DateTime in Expression

Question

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Answer 1

Something like this:

=FormatDateTime(Now, DateFormat.ShortDate)

Answer 2

Found the solution on http://ssrslearningcurve.wordpress.com/2008/08/08/using-the-dateadd-function-in-ssrs/

This gets the last second of the previous day:

DateAdd("s",-1,DateAdd("d",1,Today())

This returns the last second of the previous week: =dateadd("d", -Weekday(Now), (DateAdd("s",-1,DateAdd("d",1,Today()))))

Answer 3

Since SSRS utilizes VB, you can do the following:

=Today() 'returns date only

If you were to use:

=Now() 'returns date and current timestamp

Answer 4

In the format property of any textbox field you can use format strings:

e.g. D/M/Y, D, etc.

Answer 5

=CDate(Now).ToString("dd/MM/yyyy")

Although you are hardcoding the date formart to a locale.