CiviCRM Community Forums (archive)

I'm trying to import some test contributions to see if we can get this down and save ourselves some hours this year.

I'm using the Date Format: dd-mon-yy OR dd/mm/yy (25-Dec-98 OR 25/12/98)

It doesn't seem to matter how I format the date, it always gets an error file, with the Reason:

Invalid value for field(s) : Receive Date

As far as I can tell, the Receive Date format matches what I've chosen.

"External Identifier (match to contact)","First Name","Last Name","Contribution Type","Contribution Source","Receive Date","Thank-you Date","Cancel Date","Total Amount","Accounting Code","Payment Instrument","Check Number","Non-deductible Amount","Fee Amount","Net Amount","Transaction ID","Invoice ID","Currency","Contribution Status"
1001,"Bob","Stewart","Branch donation",,21/01/2009,,,"10.00",,"AP",,,,,,,"NZD","Completed"
1002,"Bob","Hughes","Branch donation",,21/01/2009,,,"10.00",,"AP",,,,,,,"NZD","Completed"
1003,"Bob","Craven","Branch donation",,21/01/2009,,,"15.00",,"AP",,,,,,,"NZD","Completed"
1004,"Bob","Gray","Branch donation",,21/01/2009,,,"15.00",,"AP",,,,,,,"NZD","Completed"
1005,"Bob","Mitchell","Branch donation",,21/01/2009,,,"100.00",,"AP",,,,,,,"NZD","Completed"

I'm probably doing something wrong, but can't figure out what. Any help appreciated!

Ah, thanks.

It's very hot today.