AnsweredAssumed Answered

Dates are converted to text when importing date fields from Bento.

Question asked by kentbraun on Dec 7, 2012
Latest reply on Dec 17, 2012 by kentbraun

Title

Dates are converted to text when importing date fields from Bento.

Your post

     I have a database in Bento and the date field is defined as a date - not text. When I export that database as either CSV or XLS and then import it into FileMaker Pro 12 the date field changes its type to text. If I change the field type to date it sorts differently.

     Can anyone tell me what I'm doing wrong or how to do this so that it turns out right. The FileMaker help file says it imports dates as dates. So I would expect this to work.

     Any suggests will be welcome!

Outcomes