Format Execution time

baaul · July 25th, 2006, 01:46 PM

Hello,

How would you FORMAT the execution time

using the standard "Globals.ExecutionTime" I get it as 07/21/2006 9:40:15 AM.

I would like to format this to July 21, 2006

Thanks!

-Baaul

JimReid · July 25th, 2006, 02:06 PM

:DLook in the properties for the formatting of the field. Very easy.
:)

Alvin DSouza · February 3rd, 2015, 04:18 PM

In addition to the answer this can be achieved by doing the following steps in the reporting database:
1.Go to the SQL server which is hosting your Reporting Services
2.Open the SQL Server Management studio and go to a database called "ReportServer"
3.Expand database "Reportserver"
4.Expand Tables
5.Open the table called "dbo.Subscriptions" in Edit Mode...You will see a column called "Locale"

For some reports which is showing "M/d/yyyy" format the locale will be set to value "en-US".
6.Change the value to "en-GB"

Now all your reports (including old ones) using @ExecutionTime will start showing date time in "en-GB" format i.e. "dd/MM/yyyy" format

That's it... Happy Reporting!!!