Change Date format

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  August 28, 2013 at 3:46 pm

  #277441

  I have contacted two fields field!exp1.value & field!exp2.value my results show up as 01 2013 , 02-2013.

  How can I see that as "Jan,2013" .

  ALso my data starts with June 2013 but report starts it with Jan 2013....

  Kindly advise

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 28, 2013 at 3:47 pm

  #1645759

  Here's a great article on how to format dates in SSRS:

  Formatting Dates[/url]

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP