date issue on opportunity import

**jameschance** · 2010-01-16, 06:48 PM

Hi, when performing an opportunity import, I can't get 'completed_date' to appear - the field is just blank.

I have exported an opportunity, then re-imported. None of the date fields get completed, although other info works. Below is the record:

"id","name","date_entered","date_modified","modifi ed_user_id","created_by","description","deleted"," assigned_user_id","opportunity_type","campaign_id" ,"lead_source","amount","amount_usdollar","currenc y_id","date_closed","next_step","sales_stage","pro bability","account_name","assigned_user_name"

"2f9e30df-7617-b06c-2a27-4b521245cfaa","DNA copy 3","16/01/2010 20:25","16/01/2010 20:25","de126124-aae1-406c-1859-4b4c639e978b","de126124-aae1-406c-1859-4b4c639e978b","","0","de126124-aae1-406c-1859-4b4c639e978b","","","","60000","60000","-99","28/01/2010","","Prospecting","","anvia","james"

i have made sure the Admin and My Account date format is set to dd/mm/yyyy.

Any suggestions?
Thanks,
James.

**roblaus** · 2010-01-17, 06:20 AM

When importing open the Advanced Option screen at the end of your field mapping screen. There you can set date format and character set. The settings under "my account" just help you when exporting, not importing.

**jameschance** · 2010-01-17, 06:51 PM

Thanks for your suggestion.

The import process doesn't give me an 'advanced' option at the end of the field mapping. I wonder if this is restricted to the Professional edition? I am using the Community edition.

Print Screen attached.

James.