Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Date Format incorrect in Reporting Services

I have a Date Time field in a report with format set to 31/01/2000 13:30. It says on the dialog that Formats that begin with an asterisk () will reflect the regional settings of the report.

It also confirms below that my current regional settings are: English (UK)

I then deploy to my local report server and run the report and it displays in American Date format e.g. 01/31/2009.

The local report server is set to run under my own local account which is set to UK format regional settinsg.

Where is it picking up these American settings from?

like image 897
Mark 909 Avatar asked Apr 19 '26 04:04

Mark 909


1 Answers

In BIDS or ReportBuilder NOT in the SSRS website, select "Report" in the properties window and set the language:

enter image description here

like image 106
adrianm Avatar answered Apr 30 '26 02:04

adrianm