3 Replies Latest reply: Nov 27, 2012 5:43 AM by Henric Cronström RSS

    Different date format in one field

    Gaurav Malhotra

      Hi

       

      I want to know that how to deal with this type of data attached below in the CSV format. If we have different type of date format in the data source, then how to make it look in a single format?

       

      I know below code is not right, but help me people to correct this one.

       

      This is my code:

       

      Load Date,

                Data,

                date#(date, 'DD-MMM-YYYY'),

                date#(num(date, 'DD-MMM-YYYY'))

      from .\data\Test01.csv;

       

       

      Regards,