Start a new topic

Error on datetime column during CSV Import

[This topic is migrated from our old forums. The original author name has been removed]

Hi, I am using 'Import CSV file' feature and in my csv file, the dates are in the format '03/11/2014 12:01 AM'. That format is not available in the wizard and I keep getting error due to invalid date format. Does anyone know a workaround for that? Thanks!
1 Comment

[This reply is migrated from our old forums.]

Re: Error on datetime column during CSV Import
Hi, The format fields can be edited; you don't have to use one of the default formats. You need to specify a pattern like "dd/MM/yyyy hh:mm a". Please see the Users Guide for more on format patterns: http://confluence.dbvis.com/display/UG91/Changing+the+Data+Display+Format Best Regards, Hans