Wrong date format is imported

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I exported an Excel CSV file from Lead and imported it to Target.

In Excel, the Date Created and Date Modified values and formats are correct.

But in Target, the Date Created format is wrong and Date Modified value is wrong

2

When importing, on step 2, click the button “VIEW IMPORT FILE PROPERTIES” and set the correct date format from there, that should solve it.

3

Hi pgr,

That works. Thanks!