2 Replies Latest reply: Aug 22, 2015 7:06 PM by Doug Nichols RSS

    I need to convert csv file dates to excel dates

    Doug Nichols

      Hi I am new to Datawatch and would like your help on converting csf file dates to excel dates.  I have an excel file that is in csv format.  After I do everything in the prep of data watch I need to export that data and save it back to excel and the dates need to be in an excel format.

       

      Example:

       

      The dates on the original csv are as follows:   6252015

       

      I need to save the date as 06/25/2015

       

      I'm not a techie so need something super easy. 

       

      Thanks for your help in advance.

       

      Doug