Importing date field from Excel


Viewing 1 reply thread
  • Author
  • August 16, 2021 at 6:18 AM #44996

    Kevork Hopayian

    I have previously successfully importing records from Excel into TF and the import of date fields has worked perfectly until now. I have, of course, specified the import field to be Date type, I have verified that the format in Excel is Date and tried 3 date formats in Excel, but not succeeding. Is anyone else having problems? I have even done a restart of the Mac.
    I am up to date with software using TF v5.3.19 & Excel 16.52

    August 17, 2021 at 12:35 AM #44999


    Hi Kevork,

    In Tap Forms, when importing an XLSX file, use the Excel date format for the Date Format setting on the Import Records screen. That should solve the problem. I really should make that the default when you select an .xlsx file to import.



Viewing 1 reply thread

You must be logged in to reply to this topic.