Neo Neo - 1 year ago 80
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

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

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


enter image description here

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download