I'm importing data from a tab delimited Excel file and I'm experiencing a problem with one of three Date fields not being imported,
The "Import Field Mapping" is correct but every time I import, that one Date field is missing. When I open the table layout all fields have been shifted to the left as though the Date field never existed. I've tried different file formats with the same results.
It"s a small table, 265 records that I was attempting to cleanup a mistake made with the record ID numbers. I had planned to export and renumber the records, then import them back in to the table.
I'm using FileMaker Pro 14 Advanced