Date Creation Defaults to 11.29.1999?

**pixelspace** · 2007-06-11, 01:53 PM

We imported a CSV file and mapped our "Creation Date" to Sugar's built-in "Creation Date" field and now all records have defaulted to the following date "11.29.1999 07:00PM" regardless of data in the CSV file.

See the attached file.

Any ideas?

**Angel** · 2007-06-14, 10:12 PM

This is usually the result of the date format that was entered into the field.

It should be formatted as follows:

yyyy-MM-dd HH:mm:ss

**pixelspace** · 2007-06-15, 12:05 PM

Does this mean a re-import of the data with the date in the noted format?

**Angel** · 2007-06-15, 04:21 PM

Depends.

It is possible that the correct dates are still within the database, but their formatting needs to be adjusted.

You'd have to make that modification through MySQL itself, but in general, should not involve much more than 1 or 2 SQL commands.

You could also re-import, but the problem with that is that if you've linked other items to the records in question (e.g. Calls, Opportunities, etc.), then you'd lose that linkage and you'd have to fix that part manually.