4 Replies Latest reply: Oct 3, 2014 4:34 PM by vspr n RSS

    Show date  from date field with different date formats

      Hi there i get every day a csv file that contains transaction logs from different databases. Because of this the date field has many different types of date formats in it. I include the date field in the attached excel file.

       

      I want to display all of the different date formats that are include in the field, in the following format: e.g. 11/11/2012. ( 'DD/MM/YYYY').

       

      Unfortunately the code i wrote applies to certain date formats, not to all of them.

       

       

      Any help would be very appreciated.