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

    Leading zero in date value is being removed in submission excel.

    Asked by ITU_contacts on August 25, 2014 at 08:18 PM

    Hi,

    I'm using the date of birth fields, and I am exporting the data of the form into a spreadsheet.

    I have been requested that the output be mm/dd/yyyy, for example 01/01/1980, but if the month and days are only one number, the output is 1/1/1980

    Is there a way to get the double digits also where the input is january through september, and for numbers 1 to 9?

    thank you

    date of birth and
  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 25, 2014 at 11:58 PM

    HelloITU_contacts,

    I did check this issue by creating a simple demo form and I am unable to replicate the issue you are having. When I exported the form submissions in excel, it did not remove the leading zeros from the date value. Please check the screenshot below:

    I would suggest you to test your form again and get back to us if the issue persists.

    Thank you!

  • Profile Image

    Answered by ITU_contacts on August 26, 2014 at 01:09 PM

    Hi,

    I'm afraid I made a mistake in explaining how the form works: it is connected to a google spreadsheet, therefor I don't manually export the data, it is funneled into it automatically.

     

    I'm attaching a screenshot of part of the form, with test data.

    Column L is the birthdate picker. Column M is the insert Date picker. In both cases, the output is month and day without the zero, if only one digit.

    Do you know if there is something I can do about this?

    Thank you for your help!

     

  • Profile Image
    JotForm Support

    Answered by david on August 26, 2014 at 03:01 PM

    Hi,

    I believe this formatting is done in the Google spreadsheet.  I believe you can change the formatting in the sheet itself:

    https://support.google.com/docs/answer/56470?hl=en

    Let us know if this does not work for you and we will be happy to see what else we can find.

    Thank you for using JotForm!

  • Profile Image

    Answered by ITU_contacts on August 26, 2014 at 03:07 PM

    Hi,

    yes, I ended up doing that, unfortunately every time new data gets input, it still has the format without the leading zero.

    I was hoping there was a more automatic  way to do it, instead of "formatting" every time the column.

    I don't know why it doesn't keep the format I gave for new data too, Excel does that.

     

    Thank you anyway. :-)

  • Profile Image
    JotForm Support

    Answered by david on August 26, 2014 at 04:17 PM

    It does look like it is an issue with the way the spreadsheet does the initial formatting of the data sent to it by our forms.  I did a few tests and had the same results as you.  Sorry we couldn't be more help with this.  Please let us know if there is anything else we can help you with.