vTiger – Import Date Format yyyy-mm-dd

Issue:

When import a spreadsheet in .csv format, all imported dates become 00-00-0000.

Solution:

make sure the date format of the cells in .csv must be in yyyy-mm-dd.

Tricks:

the date format selected in “My Preference” doesn’t affect the result of importing.

Configuration:

vTiger 3.0.4