Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
getting errors
That doesn't give us much to work with and help you, post your script.
Never mind, I got..Thank you so much for your help though
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