Date Creation Defaults to 11.29.1999?

[pixelspace]

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?

[pblag]

Hi pixelspace!

I think that you have a problem with date format in your csv file.
So sugar can recognize year and fill this field with default value.
please let us know what is an existing date format so we may better help you.

[pixelspace]

I appreciate the help.

The CSV file date format is: 6/1/2007 14:23

[franklin_sugar]

Hi pixelspace,

The date format has to match the format in your "My Account" settings.

Thanks,
Franklin