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

    Importing data from excel the date format is wrong

    Asked by Holidea on July 14, 2016 at 01:51 PM

    Hi,

    I imported from excel to a form submissions but the date format is wrong in form submissions and in report to.

    How can I see the date?

    Thank you

    Eva

    Page URL:
    https://eu.jotform.com/submissions/61954939935979

    excel format importing Submissions
  • Profile Image

    Answered by victor on July 14, 2016 at 02:27 PM

    To assist you better could you please indicate the form you are having issue import the dates to. I have just reviewed the form 2_Giuseppe Losa CAPOAREA rapporto contratti and did not see and date fields.

    Please give us more information so we can better assist you.

  • Profile Image

    Answered by Holidea on July 14, 2016 at 02:48 PM

    Hi Victor,

    Sorry, the date fields are:

    REGISTRATO

    CONS.DATA

    Thank you

    Eva

  • Profile Image

    Answered by victor on July 14, 2016 at 03:31 PM

    Thank you for the information. When reviewing the form again, the fields indicated are text fields and not date fields

    Since they are text fields, it is possible that it is trying to divide or subtract the date you are trying to import as it is done in excel.

    I suggest you remove these text fields and add the date fields. When importing the date, please verify the format our import app suggests.

  • Profile Image

    Answered by Holidea on July 15, 2016 at 05:40 AM

    Thank you Victor!

    I understand know.

    Thanks

    Eva