hi, with my beginner questions, i started to use data importer and i notice if i use military time format i do not get right time when i browse the column-row data?!!!
what i am doing wrong? i end up correcting them manually.
Ver.29, Ubuntu
regards
1 Like
Hi @alkindy The importer uses the PHP strtotime function to attempt to interpret dates that are given to it. However, since areas of the world use slashes with the dates in different orders, using slashes in your dates can cause ambiguity with the PHP date parser. If the separator is a slash (/), then the American m/d/y is assumed. The best date format is the MySQL ISO standard, YYYY-MM-DD for dates and HH:ii:ss for times. Hope this helps!
1 Like