Solved: How to capitalize(Month) - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-07-08

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,

Report Inappropriate Content · ‎2011-07-25

getting errors

danielrozental · ‎2011-07-25

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

Report Inappropriate Content · ‎2011-07-25

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

erichshiino · ‎2011-07-25

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