03-01-2011 08:21 AM - edited 03-01-2011 08:25 AM
I wondered if the ever helpful community could help me with this problem? I have imported a spread sheet from excel into ACT! Everything has worked fine, apart from one of the date fields. As far as I can see, the fields are set up correctly in both ACT! and excel, and the other date field has imported fine. To clarify, the field has imported in the correct date format, but the date itself is wrong (e.g.. a date of 24/02/11 now appears as 12/06/10).
Could anyone suggest how I can fix this?