Format Date

[#1]

I want to show just the first 3 letters of each month but when I use monthname show the intere name of the month.

I try to use Date(date, 'MMM/yyyy') and is also showing the entire name of the month.

There are some setting I have to change?

Thanks in advance.

[sunny_talwar · Accepted solution]

Make sure you have this in your load script:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

[#3]

Thank you