How do I format date and time on ssrs report?

Question

I've tried this = FormatDateTime(Now,"MM / dd / yyyy hh: mm tt) "on SSRS page, but it doesn't work for me to make an error. Please help me with expression. I want output shown in this way 12/4/2013 12:05

Answer 1

Input

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

Output:

04/12/2013 05:09 PM

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.