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

    Birth Date Picker Widget: Date Format when Exported to Excel

    Asked by Russ563 on April 04, 2015 at 06:24 PM

    I'm using the Birth Date Picker Widget and have a problem with its format in or out.

    I first tried DDMMYYY, but the space given to each field doesn't adjust to the width of the field.

    (This format DOES export so Excel {CSV} can read it as a date.)

     

    Then I tried the more normal format of MMDDYYYY, the size of the fields fit, well almost.

    But the export provides a format of the month spelled out, then the day, then the year: i.e. January 1 2000

    The problem is it is missing the comma after the day. i.e. January 1, 2000  Without the comma Excel sees it as text and NOT a date, and therefore I can't change the format in Excel. I need the format of MM/DD/YYYY (all numbers with slashes in between) to import to another program. All I did was add the comma and Excel converted it to whatever date format I chose.

     

    Page URL:
    http://form.jotform.us/form/41748752369164

    format date picker widget problem size excel CSV
  • Profile Image

    Answered by Shadae on April 04, 2015 at 08:21 PM

    Hi Russ563,

    Thank you for contacting us.

    I was able to reproduce the issue that you are experiencing with exporting your data that have been entered in the Birth Date Widget into excel.

    I have passed on this request to our back-end team to have the data exported to Excel in a data format.

    Any update on the request will be posted to this thread.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by TitusN on August 25, 2016 at 01:55 AM

    We've fixed it - Excel exports will have a proper date format data. 

    Please check - let us know. 

  • Profile Image

    Answered by snjrose on September 17, 2016 at 05:19 PM

    I am having a similar problem with birth date picker. The date is written out in Jotform (ie. January 7, 1968), but when I export to an Excel file, it changes it to 01/07/1968. I don't want it to convert to numbers. I merge the field into a letter, and I want it written out as January 7, 1968. How can I make sure it doesn't get changed into numbers in the Excel download? It didn't used to do this. Please help me fix it back to the way it was.