Jotform dates don't come in as dates in Excel. When I try to convert the column in Excel, it does not.

  • Profile Image
    Asked on June 06, 2012 at 09:50 AM
  • Profile Image
    Answered on June 06, 2012 at 01:58 PM

    Last month a ticket was submitted to our developers about this issue. While they're working on it, you can substitute Date Time fields for all of the form's Birth Date Picker fields, as suggested in this thread.

    However, before doing so, you will need to backup all of the form's current submissions to your computer because the data in the Birth Date Picker fields will be deleted along with the fields. After inserting the Date Time fields, you will need to manually enter the dates into the current submissions. That can be done by loading each record into the top section section of the form's submission page, clicking the Edit button, entering the dates and clicking the form's submit button.

    Our apologies for the inconvenience.