Imported dates are backwards and text

Discussion created by AndrewTaggart on Sep 23, 2015
Latest reply on Sep 24, 2015 by nicolai



I have exported a database from Bento as an Excel file and imported it into Filemaker 12.


There are date fields and date time fields that have come out looking like:


Date: 2003-12-12

DateTime: 2011-03-29T12:00:00


I have mangaged to change the "-" to "/" but when I convert the field from text to date all I get is "?"


1, How can I make this field into a date field?

2, And the same for the Date time fields?


I have tried the Bento migration tool but it crashes even though address book is turned off and I am using Yosmite.

I have tried to widening the field but still get ?


Help please