FormatDateTime command
Command Result
FormatDateTime(Parameters!Date.Value,1) Tuesday, February 10, 2011
FormatDateTime(Parameters!Date.Value,2) 2/10/2007
FormatDateTime(Parameters!Date.Value,3) 12:00:00 AM
FormatDateTime(Parameters!Date.Value,4) 00:00
Format command
Command Result
Format(Parameters!Date.Value,"dd-MM-yyyy") 10-02-2011
Format(Parameters!Date.Value,"dd/MM/yyyy") 10/02/2011
Format(Parameters!Date.Value,"MMM-dd-yyyy") Feb-10-2011
Format(Parameters!Date.Value,"MMM-dd-yy") Feb-10-11
Format(Parameters!Date.Value,"MMMM-dd-yy") February-10-11
Format(Parameters!Date.Value,"MMMM dd yyyy") February 10 2011
Also this expression:
=Day(Parameters!AsOfDate.Value) & "/" &
Month(Parameters!AsOfDate.Value) & “/” &
Year(Parameters!AsOfDate.Value)