Formatting

Formatting Dates in SSRS

In Reporting Services, formatting dates can become a headache for the developer, often due to differing regional settings on servers, development boxes etc. Therefore I've found it much more useful to force the report to use a particular format, rather than allow the server settings to decide for me. Previously I would have used FormatDateTime in the expression, as shown here: =FormatDateTime(Fields!DateStamp.Value, DateFormat.ShortDate) Depending on the regional settings, this could return either 12/3/2008 or 3/12/2008.