Search code examples
sqlreporting-servicesssrs-2008

How do I format date and time on ssrs report?

In an SSRS report I need to show today's date and current time.

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

How can I write this expression ?

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

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

    Output:

    04/12/2013 05:09 PM

    Full list of format options might be found here. Kudos to @MattGibson.