sqlreporting-servicesssrs-2008

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

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.