Import activities - format dd/mm/yyyy not working

[clarkac]

If you select the date format dd/mm/yyyy when importing activities in 4.3.1 (don't know about other releases) then Civi ignores that and assumes yyyy/mm/dd.  So some records will be rejected and some corrupted.   Easy workaround is to reformat your input dates to yyyy/mm/dd.  I've raised this issue http://issues.civicrm.org/jira/browse/CRM-12417

[kennedy]

Hi,
I have been trying to import activities but with no luck, Invalid value for field(s) : Activity date
I have attached two files, the initial file and the error report file. The activities marked in red are the only activities not imported, it seems if day is >12, it throws an error. Any ideas? I have been having the same error messages on my site and on the demo site as well.
Here is the link to the successful activity import on the demo site http://drupal.demo.civicrm.org/civicrm/activity/search?_qf_Search_display=true&qfKey=39fbcd123ef3008cdde88452c7ee224d_9621

Any hint will be of great help.

[clarkac]

...then I would assume you selected dd/mm/yyyy instead of mm/dd/yyyy which is why you get the error... you don't say what you selected.

[joanne]

I seem to remember that there was a bug related to this that was fixed in later versions of 4.4.X series.  An upgrade to 4.4.6 may fix your problem. 

You should upgrade anyway as 4.4.6 included security fixes.

[kennedy]

Hi Joanne and Clark,
thank you for you time, it seems  mm/dd/yyyy works, have just tested it in an old install running 4.4.3. Will also run it on a new install later today and report back.

Setting the date format in administer>Localization>Date formats is not enough, the same date format has to be also selected on the first screen (Contacts > Import Activities) during import.

Many thanks

[kennedy]

also works with format mm/dd/yyyy on 4.4.6 but setting date format in administer>Localization>Date formats is not enough, the same date format has to be also selected on the first screen (Contacts > Import Activities) during import.

Thanks

[clarkac]

Yes, that's true you have to specify the date format on all the import screens.  This makes some sense as the file you are importing may have the date  formatted differently from your usual format.