How do I format date and time on ssrs report?

sql reporting-services ssrs-2008
Neo picture Neo · Apr 12, 2013 · Viewed 374.4k times · Source

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

Answer

Ian Preston picture Ian Preston · Apr 12, 2013 
=Format(Now(), "MM/dd/yyyy hh:mm tt")

Output:

04/12/2013 05:09 PM

Related questions

How do I display todays date on SSRS report?

I want to show up Todays date as report generated date on SSRS report. How can i do that ? should I use any variable ? please help me I'm newbie to SSRS. For example refer this image:

Read More
"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB …

Read More
Generate report from URL - SQL Server Reporting Services 2008

I have SQL Server Reporting Services 2008 and when I open the following URL: "http://localhost/Reports/Pages/Report.aspx?someReport" I'm getting report screen in which I fill my parameters and generate a report, My question is how can I …

Read More