converting date from mm/dd/yyyy to dd/mm/yyyy in SSRS

Question

I have datetime type from DB table.

In SSRS report, I'm getting datetime format mm/dd/yyyy. I want to change it to dd/mm/yyyy.

I have added expression like:

=FormatDateTime(Format(Fields!TransactionDate.Value,"dd/MM/yyyy"),DateFormat.ShortDate)

But, this is showing #Error in the report. How to correct this?

Answer 1

If the field in the data set is datetime, then the expression to use is

=FORMAT(Fields!Dataset_Field_Name_Here.Value,"dd/MM/yyyy")

From looking at the expression, the 'DateFormat.ShortDate' is using the language set for the report? Goto report -> properties -> Localization -> Language. I set it to en-GB so that it will display dates in the format l require. However this value if l remember correctly can be overridden by the language settings on the client computer displaying the report.