CODEWITHSUNDEEP
datereporting-services
Green Lantern
Green Lantern

Reputation: 868

Localizing date on SSRS

I'm using the d Format on the date field

So when the report's Language is on German(de), July 22, 2012 appears as:

22.07.2012

When I switch the report's Language to English(en), July 22, 2012 appears as:

7/22/2012

How can I make the English date appear as 07/22/2012? i.e. the dates should appear as two digits regardless of the month being two digits or single digit

Upvotes: 0

Views: 704

Answers (2)

Gowdhaman008
Gowdhaman008

Reputation: 1323

You can use the following expression in you report to show the date in dd/mm/yyyy format. Following screenshot shows date time with and without modification to the expression.

Expression:

=string.Format("{0:MM/dd/yy}",Fields!ModifiedDate.Value)

Without modification

Without modification

With Modification: With Modification

Hope this helps!

Upvotes: 0

Denis Palnitsky
Denis Palnitsky

Reputation: 18387

You can use custom date format such as MM/dd/yyyy. If you need custom format only for English report then you can use expression =IIf (User!Language = "en", "dd\mm\yyyy", "d")

Upvotes: 2

Related Questions