Format date of a field in SQL Reporting Services

Question

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

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

sanjeev.das Grasshopper Points: 20 More actions · Answer 1

Hi,

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

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

jyothi.vedam SSC Journeyman Points: 95 More actions · Answer 2

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

sanjeev.das Grasshopper Points: 20 More actions · Answer 3

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]