4 Replies Latest reply: Oct 25, 2012 2:53 AM by Stefan Wühl RSS

    DATE function, need help

      Hi All,

      i am trying to convert date format from DD-MMM-YY(15-Oct-12) into DD/MM/YYYY(15/10/2012)

      i tried no. of ways as below:

      DATE(DATE#(FIELD),'DD/MM/YYYY')

      DATE(DATE#(FIELD,'DD MMM YYYY'),'DD/MM/YYYY')

       

      But, i am getting empty fields only.

      any help much appreciated.