Community
Showing results for 
Search instead for 
Do you mean 
Reply

Date import error

Astute Commentator
Posts: 21
Country: United_Kingdom

Date import error

[ Edited ]

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?

 

Thanks!