CiviCRM Community Forums (archive)

Hi
I have a problem importing some data with CiviCRM Import.
I have a big data file with many infos (first and last name, address, postal code, date, etc) I already imported it without date, now I have to re-import it with date field.

I created a date field called "Latest donations" by:

Custom Data -> New Group of Custom Fields -> Custom Fields

Included date parts Month, Day and Year
Field Searchable and Serarch by Range.

I have this CSV file with data in different formats

Dec. 6, 2002
5/31/1999
September 22, 1998

using MS Excel I tride to standardizing it by right click and "Format Cells" -> Date: March 14, 2001.

It looks like while converting from xls to csv format it does not save anything.

I get generic errors (I removed other data):

Line Number   Reason   last-donation
1   Invalid value for field(s) : last-donation; last-donation   Nov 4 1994

do you have any ideas?