After the upgrade from SQL Server 2005 to SQL Server 2008 it was noticed that three of our servers generated the date in the American format i.e. mm/dd/yy for the @ExecutionTime parameter in the Subject field of the “Report Delivery Options” page of the report subscription.
Solution:
The American date format issue in the SSRS subscriptions for the @ExecutionTime parameter can be resolved by changing the value of the “locale” field in the “Subscriptions” table of the “ReportServer” database to en_AU i.e. english Australia
update dbo.Subscriptions
set locale = 'en-AU'
