faizan ahmad

Usually the things which were not a straight Google
  Home  |   Contact  |   Syndication    |   Login
  17 Posts | 0 Stories | 68 Comments | 0 Trackbacks

News

Archives

Post Categories

.NET

ASP.NET

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

 

 

 

posted on Wednesday, August 19, 2009 4:02 PM