Importing date field from Excel

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Importing date field from Excel

Tagged: 

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

    Kevork Hopayian
    Participant

    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

    Brendan
    Keymaster

    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.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.