using datename function to return month in 3 character format
Posted on 2008-11-03
I am using the datename function to return the month that an invoice was created, however, it returns full months, like January, February, etc. Is there a way to return 3 character month names, like Jan, Feb, Mar, etc? If not, is there a way to only pick up the first 3 characters in the month field?