What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

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

    Asked by pressberg on June 06, 2012 at 09:50 AM
    Page URL:

  • Profile Image
    JotForm Support

    Answered by abajan 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.