I need to determine the month name as a calculated column into a Time table with a date field as the pk of the table.
I've used this formula: FORMAT(MONTH([Data]);"mmm")
Month names don't correspond with the month.
Any suggests, please?
This one came up yesterday too.
To use a date format (like "MMM" for month name), you need to pass the function a proper date. Not just an int for the month part.
Try passing the full date (remove the MONTH() function). And uppercase MMM is needed for month name abbreviated.
Let me know if that helps.
Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com
Ok, Brent, it functions. Many thanks.
I've read this blog:
So I think it was wrong.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?