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

    Time information does not have a separator in the imported data

    Asked by CNSTradingLtd on January 19, 2017 at 05:39 AM


    I am using your Excel Import facility - import.jotform.io

    When I import an Excel Date Time field such as this 26/10/2015 16:28

    the contents of the Field in Jotform does not have the colon and looks like this 26/10/2015 16 28 

    Any ideas




  • Profile Image
    JotForm Support

    Answered by Welvin on January 19, 2017 at 07:11 AM

    I can see that. Would you mind letting us know how did you get the source file? Is it from another form? If so, please share us the excel file or the form URL so we can also check. You can send the file to support@jotform.com. Please don't forget to put this thread in your email as reference.

    I would also like to mention that when you edit the submission, the date is placed in the year box:


    I will forward this to our developers, but I need to check the source file first for proper documentation.