6 Replies Latest reply on Dec 17, 2012 8:04 PM by kentbraun

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

    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!