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

    Birthdate picker Export to Excel format

    Asked by KYSC on April 18, 2012 at 06:03 PM

    I have a form with Birthdate Picker.  When I output to Excel, the birthdates are formated as text.

    Ex: October 31, 2000

     

    Would like them to format as date

    Ex: 10/31/2000

     

    Or a separate column for each

    Ex:

    Column A: 10

    Column B: 31

    Column C: 2000

     

    Is this possible?

  • Profile Image
    JotForm Support

    Answered by Mike_T on April 18, 2012 at 06:32 PM

    Thank you for contacting us.

    I am afraid that this is not something that you can configure from your side. However, you may consider using DateTime field instead of Birth Day Picker.

    To get the date format like this.

    If 10-31-2000 format is not acceptable for you, I can raise a ticket to our Development Team in order to switch the output to 10/31/2000, but I can not say when or if this request will be processed.

    Please let us know if you need any further assistance.