Format dates in SSRS reports

Displaying dates in different formats in your reports is a very common requirement that one faces while working with Sql Server Reporting Services (SSRS).

Let us see how we can display dates in different formats :

=Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08

=Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008

=Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08

=Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 =Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50

=Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008

Original Source: http://www.sqlservercurry.com/2008/02/format-dates-in-ssrs-reports.html