Menu Close

Format Date

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)