SSRS Reference Material

Report Dates & Date Functions

Date Functions

FormatDateTime(Parameters!Date.Value,1) = Tuesday, April 10, 2007
FormatDateTime(Parameters!Date.Value,2) = 4/10/2007
FormatDateTime(Parameters!Date.Value,3) = 12:00:00 AM
FormatDateTime(Parameters!Date.Value,4) = 00:00

Format(Parameters!Date.Value,”dd-MM-yyyy”) = 10-04-2007
Format(Parameters!Date.Value,”dd/MM/yyyy”) = 10/04/2007
Format(Parameters!Date.Value,”MMM-dd-yyyy”) = Apr-10-2007
Format(Parameters!Date.Value,”MMM-dd-yy”) = Apr-10-07

=FORMAT(Today(),"M/d/yy") = 8/23/10
=FORMAT(Today(),"MM-dd-yyyy") = 08-23-2010
=FORMAT(Today(),"MMM-dd-yyyy") = Aug-23-2010
=FORMAT(Today(),"MMMM dd, yyyy") = August 23, 2010
=FORMAT(DateField,"MMM dd, yyyy hh:mm:ss") = Aug 23, 2010 01:43:33
=FORMAT(DateField,"MMM dd, yyyy HH:mm:ss") = Aug 23, 2010 13:43:33
=FORMAT(DateField,"MMM dd, yyyy HH:mm:ss.fff") = Aug 23, 2010 13:43:33.587
=FORMAT(DateField,"MMM dd, yyyy hh:mm:ss tt") = Aug 23, 2010 01:43:33 PM