Post reply

date become 19/08/2005 12:00:00 AM when export to csv

  • June 8, 2006 at 5:41 pm

    #76535

    Hi,

     

    I am using “Transfer Text” in macro ( import delimiter)  to import data and the date is short date ( 19/08/2005)

    Then I also use “Transfer Text” ( export delimiter) to export to csv

    But when I look at the csv file, my date column become 19/08/2005  12:00:00 AM

     

    I want the date as 19/08/2005

     

    Any idea  

     

    thanks,

    Susan

  • June 9, 2006 at 6:05 am

    #642754

    When you're doing the export, instead of just exporting the field, export Format(myDate,"Short Date"). Your date is stored with the time, as part of the way the datetime data type is structured.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply