Migrating from ACT!

When I imported 3000 or so nodes from my ACT! database into a local Drupal site it all worked well but because all the dates were in dd/mm/yy format they would not import using Node import .

I opened the .csv file in Excel and added two columns:
'(unix) Create Date' for Create Date
and
'(unix) Edit Date' for Edit Date
I then used this formula to make the Unix timestamp
=IF(A1, (A1-25569-(-5/24))*86400,"")
Note:
A1 is the cell that contains the dd/mm/yy or mm/dd/yy (your computer knows about the way you format dates in your country) and the 5 is to set the time to 5am.