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

    How to capitalize(Month)

    Nick Gan

      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,