How to capitalize(Month)

[#1]

Hi,

I have a field with data like Jan 2011.

But, some values are in JAN 2011, some are Jan 2011.

How can i standardize all to says Jan 2011?

i tried the following, but i didn't work.

DATE#(capitalize(MONTH_YEAR), 'MMM YYYY') as MONTH_YEAR,

[#2]

getting errors

[danielrozental]

That doesn't give us much to work with and help you, post your script.

[#4]

Never mind, I got..Thank you so much for your help though

[erichshiino · Accepted solution]

Going back to the syntax of your first post, maybe you just need to include the month names in a capitalized form in the beggining of the script:

SET MonthNames='JAN;FEB;MAR ...

Hope this helps,

Erich