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

    Date format in extracted data

    Asked by Krishna  on January 30, 2014 at 06:22 AM

    Hi Support,

     

    I have captured information through DateTime field in quick tools. But, I am not getting dates in proper format when i download the submissions in excel/csv format. 

     

    Please help me on this.

     

    Regards,

    Krishna

    format Submissions DateTime field excel CSV
  • Profile Image

    Answered by EliezerN on January 30, 2014 at 09:32 AM

    Hi,

    I was not able to reproduce the issue from my end. Kindly check the date format of your Excel spreadsheet is the desired one, if not kindly try changing it to the you need it to be.

    If the issue still persists, do not hesitate to contact us.

    Thanks

  • Profile Image

    Answered by EliezerN on January 30, 2014 at 09:38 AM

    Here are the screenshots of my tests:

    - In Submissions page:

    - In Excel:

    So, make sure that the date format you are using in the Date field of your form is also the correct one:

    Thanks