Post reply

Format date of a field in SQL Reporting Services

  • April 13, 2011 at 2:02 am

    #236681

    I have date field in my report in format dd/mm/yyyy(2/02/2011).I want to display it as Feb-11.Please let me know how we can do this?

  • April 13, 2011 at 3:46 am

    #1310891

    Hi,

    Have you tried Custom Format MMM-yy? This might work.

    [font="Arial"]http://reportingservices.blog.co.uk/[/font]

  • April 13, 2011 at 4:28 am

    #1310913

    Thanks for the response.

    I have tried the following expression

    =Format(Fields!WorkedOn.Value,"MMM,YY")

    But still date is displayed in d/mm/yyyy format

  • April 13, 2011 at 5:14 am

    #1310931

    Try this,

    Select the cell from the table with Date field, then from Properties window, go to Format and type MMM, yy

    That's it.

    [font="Arial"]http://reportingservices.blog.co.uk/[/font]

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply