13 Replies Latest reply: Jul 25, 2011 8:50 PM by Erich Shiino RSS

    How to capitalize(Month)



      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,