6 Replies Latest reply: Nov 22, 2013 6:14 PM by Surya Surya RSS

    DATE CONVERSION

    Hardik Gandhi

      I have a Data Warehouse Table with the Calendar table having its date fields in the following format:

      YYYYMMDD

       

      Now I would like to convert it to MM/DD/YYYY.

       

      I am currently using the following during my load:

      Date(Date#(RECEIPT_DATE,'YYYYMMDD'),'MM/DD/YYYY') as %RECEIPT_DATE

       

      But it's not giving me the right result.

       

      Regards,

      H