Sunday, February 26, 2012

format month name in chart

I'm trying to format the month name in a chart. I have dates, such as 1/31/2006, 2/28/2006 etc. I want them to display as Jan, Feb, Mar etc.

I know I can put 'P0' in the format field to format as a %.

Is there a format for the month name?

Yes, DateName(DatePart(month,"1/31/2006"))

Hammer

No comments:

Post a Comment