Capitalize and Abbreviate

[snehasimha]

Dear All

I want to capitalize and abbreviate the field month.How do i use both the formulas together.Kindly help me .

Regards

Sneha Simha

[hic]

Make sure that the MonthNames in the beginning of the script are the way you want them.

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

Then the Month(Date) function will return what you want.

[snehasimha]

Thank you  Henric_Cronström

Mine is an excel data uploaded, i want to use the functions .

Regards

Sneha Simha

PREVIEW

[MarcoWedel]

please post some examples of what you have and what you want