Blog Stats
  • Posts - 14
  • Articles - 0
  • Comments - 14
  • Trackbacks - 0

 

<< Add new column/field in Oracle DB table - ora - 30649: missing Directory | Home | Hide table column Dynamically in SQL Server Reporting Services (SSRS) >>

Format Date in SQL Server Reporting Services

compared to FormatDateTime Good old 'Format' function makes the job a lot easier :

 

  1.  Format(Fields!ResultDate.Value,"M/d/yyyy")
  2. Format(Fields!ResultDate.Value,"yyyy")

=IIF(Parameters!MonthlyOrYearly.Value.Equals(Monthly"),Format(Fields!ResultDate.Value,"M/d/yyyy"),Format(Fields!ResultDate.Value,"yyyy"))

 

 

 

Print posted @ Wednesday, August 19, 2009 4:02 PM

Feedback

No comments posted yet.

Post a comment





 

 

 

 

Copyright © faizanahmad