17 Replies Latest reply: Mar 23, 2017 5:58 AM by Akpofure Enughwure RSS

    Date Format

    Akpofure Enughwure

      I have a date field whose format is MM/DD/YYYY.

       

      My prefered format is DD/MM/YYYY

       

      How do I convert it to the prefered format

       

       

      Regards

       

       

      _________________________________________

      [Inflow]:

       

      LOAD

           [Date]as [Inflow_Date],

          [ASSET] as [Inflow_Asset],

          [CATEGORY] as [Inflow_Category],

          [YEAR]  as [Inflow_Year],

          [AMOUNT_k] as [Inflow_AMOUNT_k],

          [AMOUNT_j] as [Inflow_Amount_j]

      FROM [lib://WIN-WIN/xxxxx.xlsx]

      (ooxml, embedded labels, table is Inflow);