Hiya, I've set up a subscription on Reporting Services so that report goes out every day to specified emails. However, the date in the subject is showing as American (MM/DD/YYYY) rather than English (DD/MM/YYY) and the Manager who receives the report would like this amended. The default expression when creating new subscription is:'@ReportName was executed at @ExecutionTime' so the date is the value specified by the @ExecutionTime parameter. How can I amend this so that it is an English date? The actual report that I'm subscribing has en-GB settings and the Windows OS on the report server is set to English date settings yet when go into my subscriptions on Reporting Services, as well as the @ExecutionTime issue, the dates in the 'Subscription Processing Options' and the 'Report Parameter Values' are Americanised. Is it possible to change these to English as well? Cheers, AndySugs

It looks like the USA format but it works just fineBest Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance

Hi Uri, Thanks for your reply. The settings in the 'Subscription Processing Options' and the 'Report Parameter Values' does work fine and is not really a major issue - was more just curious if could be changed to english date style. However, the date shown in the subject of report subscriptions, via the @ExecutionTime parameter, is an issue as the Managers who receive the report by email want it to be in an English format Is it possible to amend the @ExecutionTime parameter date format to be English - as is possible on Visual Studio? Or will I have to stick with it being American? Cheers, AndySugs