Data Type on report is different than Data Source

Answers

• 

  

  0

  Sign in to vote

  Hello Rhythm,

  can you try this.

  =FormatDateTime(your field datacolumn , DateFormat.ShortDate)

  replace the data expression in report with above expression.

  put your data field column at place of bold place.

  • Proposed as answer by Katherine Xiong Wednesday, March 5, 2014 3:35 AM
  • Marked as answer by Katherine Xiong Tuesday, March 11, 2014 12:33 PM

  Tuesday, March 4, 2014 11:13 AM
• 

  

  0

  Sign in to vote

  you can apply format function to show just the date

  ie like below

  FormatDateTime(Fields!DateField.Value,2)
  or
  Format(Fields!DateField.Value,”dd/MM/yyyy”)
  etc 

  
  depending on what format you want

  ---

  Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

  • Proposed as answer by Katherine Xiong Wednesday, March 5, 2014 3:36 AM
  • Marked as answer by Katherine Xiong Tuesday, March 11, 2014 12:33 PM

  Tuesday, March 4, 2014 11:15 AM
• 

  

  0

  Sign in to vote

  Hi,

  You can also try like this ,

  =FormatDateTime(Now, DateFormat.ShortDate) 
  =CDate(Now).ToString("dd/MM/yyyy")
  

  
  Also try this link - http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/

  ---

  sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

  • Proposed as answer by Katherine Xiong Wednesday, March 5, 2014 3:37 AM
  • Marked as answer by Katherine Xiong Tuesday, March 11, 2014 12:33 PM

  Tuesday, March 4, 2014 11:35 AM