AndrewTaggart

Imported dates are backwards and text

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

Hi,

 

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

Outcomes