[sql] 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

This question is related to sql reporting-services ssrs-2008

The answer is


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

Output:

04/12/2013 05:09 PM

Similar questions with sql tag:

Similar questions with reporting-services tag:

Similar questions with ssrs-2008 tag: