Neo Neo - 4 months ago 10
SQL Question

How do I format date and time on ssrs report?

on SSRS report I need to show

todays date and current time


i tried this
=FormatDateTime(Now,"MM/dd/yyyy hh:mm tt")
but this is not working for me giving an error.

Anyone please help me for
expression
?

I want output display like
4/12/2013 12:05 PM

Answer
=Format(Now(), "MM/dd/yyyy hh:mm tt")

Output:

enter image description here

Comments