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