[This topic is migrated from our old forums. The original author name has been removed]
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?
over 7 years ago
[This reply is migrated from our old forums.]
Re: Error on datetime column during CSV Import
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: