I'm wondering if there is a setting in SSRS to indicate the date format. We need to show the dates in dd/mm/yyyy format on the reports and from what I can see in database the value has been stored this way. However when I put the data field from the data set (presented by a stored proc), SSRS changes the date to mm/dd/yyyy format!
For example I have contact date in the table as :1972-02-20 00:00:00.000 and want to show it 1972/02/20 on the report, but SSRS shows it as 2/20/1972.
Any idea why and how to fix it?