Trouble Importing Opportunities from CSV

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

:ohmy:

I have tried again and again to import my opportunities, but no matter what format I use for “Expected Close Date”, I get:

Error: Invalid date string
Field Name Expected Close Date: (date_closed)
Value 09/03/2015 08:00pm

Aiiiiiiiiiiiiigh! Help!

#2

Possibly try exporting a single record with a valid date and importing it to see if you still get the same error. Might be a problem with the database but first I would try exporting and importing a record and seeing if the error still occurs.

1 Like
#3

Excellent thought. I will try and report back.

#4

That resolved the issue. Thank you SO much.

It would seem that the closing date, unlike the other date fields, can NOT have a time in it.

David