Import dates

  • Profile Image
    dkirby
    Asked on October 30, 2020 at 08:26 AM

    Several of the fields in my imported table were dates. Import didn't give me a date option, only text fields. How do I get my excel dates (ie. 44128) formatted into readable dates?

  • Profile Image
    VincentJay
    Answered on October 30, 2020 at 09:32 AM

    Hi,

    Unfortunately, our import tool (https://www.jotform.com/help/308-import-app:-easily-import-your-excel-or-csv-data-into-jotform) cannot convert serial numbers to dates. Please try the dates formatted as a Text.

    Let us know if you need further help. Thank you!