Importing Dates Problem in 6.0.0

[Peter Cooper]

Hi,

I am trying to import some CSV exports from Salesforce into Sugar CE.

In trying to import dates fron the CSV (such as last modified date, or assigned to date) the datetime fields error.

The locale settings are set to the same format as the import data, except the time is only hrs/minutes where the he CSV shows hrs/minutes/seconds i.e. "23/01/2010 12:02:43" as the date time format.

Any ideas where I'm going wrong?

Thanks

Peter.

[stjohnst]

I was having this same problem, and this worked for me:

When you get to the data mapping page of the import process, select "Advanced Options" at the bottom of the page. On the Time Format dropdown, select 23.00, then begin the import.

Mine was defaulting to 11pm and creating errors, but this seemed to fix it.