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?

Is the underlying data type string or datetime? – Ian Preston Jun 20 '14 at 09:58 — Ian Preston, Jun 20 '14 at 09:58

score 24 · Answer 1 · answered Jun 20 '14 at 10:00

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.

Report Properties showing Localization -> Language

score 11 · Answer 2 · answered Jun 20 '14 at 10:07

11

Got solution:

 =CDate(Fields!TransactionDate.Value).ToString("dd/MM/yyyy")

answered Jun 20 '14 at 10:07

bapi

1,903
10
34
59

score 9 · Answer 3 · answered Jun 20 '14 at 17:50

9

Go to textbox properties: Before changing the Custom to dd/MM/yyyy (as shown), select option Date and select format MM/dd/yyyy i.e. 01/31/2000 in RS 2008. Hope it helps.

enter image description here

answered Jun 20 '14 at 17:50

p2k

2,126
4
23
39

score 0 · Answer 4 · answered Nov 01 '22 at 18:43

0

Format(Cdate(Fields!TransactionDate.Value),"dd/MM/yyyy")

answered Nov 01 '22 at 18:43

Edward Medvinsky

1

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

4 Answers4