How to display date in format of dd-MON-yyyy?

• naisu1383

  Old Hand

  Points: 380

  More actions

  August 6, 2012 at 11:23 pm

  #265329

  I have textbox for Date which displays Subscription_date field of dataset1 in format dd-mm-yyyy. Now i want this format to be done in dd-MON-yyy where MON is like JAN, FEB etc. And expression for date fields right now is

  =First(Fields!SUBSCRIPTION_DATE.Value, "DataSet1")

  However, specifying this as

  =Format(Fields!SUBSCRIPTION_DATE.Value, "dd-MON-yyyy") throws an error like expreesion can refer to field within current dataset aggregate.

  So how to write an expression with date format and dataset as well.

• deepzzzz

  SSCrazy

  Points: 2890

  More actions

  August 6, 2012 at 11:26 pm

  #1522387

  Please check this...

  SELECT CONVERT(VARCHAR(11), subscription_date, 106) AS [DD MON YYYY]

  Thanks

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  August 7, 2012 at 2:56 am

  #1522446

  Use the dd-MMM-yyyy format string instead.

  Check this link out for other format strings

  http://msdn.microsoft.com/en-us/library/8kb3ddd4%28VS.71%29.aspx