Menu Close

Tag: reporting

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)……