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 value is added on date fields when submissions are exported to Excel

    Asked by MartinSA on May 01, 2015 at 08:23 AM

    Sinds yesterday the Excel reports outputs a different format with date and time fields. In the date field (wich we set as date only) now the time is also given (see screenshot, no data is needed after the comma). Because we use formula's on the Jotform generated Excel reports, these formula's are broken now. I want to know if this change is permanent or temporary so we can choose to update our formula's (and Macro's). Thanks in advance for your response.

    Screenshot
    excel Reports date and time date field time did not match submission time
  • Profile Image
    JotForm Support

    Answered by Charlie on May 01, 2015 at 11:46 AM

    Hi,

    Have you checked the date field if the Time is enabled? I tested your form and downloaded an excel report, it gave me these values:

    Have you tried downloading the submissions again? I assume you prefer the "date" only? If that is the case, make sure that the "Time" option in the date field is not enabled.

    If you are using the Date field with "Time" enabled on it, you might need to update the formulas you are using to get the correct result you are looking for.

     

    Do let us know if re-downloading the excel report shows the same problem.

    Thanks.

  • Profile Image

    Answered by MartinSA on May 04, 2015 at 04:20 AM

    Hi, thanks for your answer. I am familiar with the time setting in the date field, but that's not the cause because the form itself wasn't changed for some weeks now. I even just checked by enable and disable the time field, with no result. Also see my new screenshot, where Excel see the field as date and "time" (in reality it is no time but just an extra number, thats why I showed the decimal number in my previous screenshot). There must have been an dev update on the report system.

    I know from the past that this happens regularly with Jotform. You are making an update to a system in the background and unintentionally something break or the workings of a certain part change. It is a good thing that you are trying to make things better, but if you use the system professionally it is to unreliable.

    Hopefully you can tell what maked this change, I'm afraid if we change the formulas that the change is reverted some time and we must update the system again.

     

     

  • Profile Image

    Answered by raul on May 04, 2015 at 09:54 AM

    I can see what you mean when I cloned your form for testing purposes I was able to see that the field is sent to the Excel file with a time value.

    Let me pass this thread to our back end team so they can check it out.

    You'll be notified here when an update regarding this matter shows up.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on May 06, 2015 at 11:12 PM

    Hello,

    We have made some changes, could you please let us know your experience?

    Kind regards

  • Profile Image

    Answered by MartinSA on May 07, 2015 at 08:33 AM

    Thanks for the efforts. Unfortunately it still shows the wrong data. 

    For example:

    The submission data and time of a few consecutive submissions are:
    6-5-2015  8:01:27
    6-5-2015  8:42:20
    6-5-2015  8:42:29

    Yet the data in the data colomn for the submissions says:
    6-5-2015  5:16:52
    6-5-2015  5:16:52
    6-5-2015  5:16:52

    Where it only need to have data of the date. The timestamp is wrong and does not have the correct time. 

    It also happens with other columns with time only. With some submissions it shows 1-1-1900  0:30:00 where it actually has to be 12:30. If i search for the original submission it shows the correct time of 12:30. So it is going wrong in the Excel report.

  • Profile Image
    JotForm Support

    Answered by Charlie on May 07, 2015 at 10:22 AM

    I'm not sure if what you are referring to the date data, is it the submission date columns? I see they are the same in your account and the excel:

     

    Although, I do see the problem with the time data where the 12:00 is converted to 00:00 in your end.

    I then compared the list of submissions in your account and in excel.

    The problem is that the excel report reads it as 12:00 AM and converts it to 24 HR format which is 00:00. Which is incorrect.

    I will notify the developers about this problem. Apologies for the inconvenience.

     

  • Profile Image

    Answered by MartinSA on May 08, 2015 at 04:34 AM

    Ok thanks. No I meant that using the date function it is showing a time also which is not even the real time of the submission. The submission column shows that. The wrong data is shown in the colomn named "Datum van vandaag:"

  • Profile Image
    JotForm Support

    Answered by Jan on May 08, 2015 at 09:53 AM

    If I understand you correctly, you mean that the time in "Datum van vandaag" is not the same with "Submission date" right?

    This ticket was already escalated to our developers. We'll notify you once an update is available. Thank you. 

  • Profile Image

    Answered by MartinSA on May 11, 2015 at 04:01 AM

    Yes, I meant that. Thanks!

  • Profile Image
    JotForm Support

    Answered by Jan on May 11, 2015 at 08:52 AM

    Thank you for your confirmation. We'll let you know via this thread once we have an update about this issue. Thank you for your patience.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on May 22, 2015 at 02:05 AM

    Hello,

    This issue should be fixed now. Could you please let us know about your experience?

    Kind regards

    Alp

  • Profile Image

    Answered by MartinSA on May 22, 2015 at 04:36 AM

    Yes the dates are fixed now, but still the times are converted just as Chris found out. Hopefully you can fix this last issue.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by Jan on May 22, 2015 at 06:14 AM

    Glad to hear that the dates are now fixed. I checked your form submissions in Excel and I didn't see anymore problems. The time is not showing anymore in the column "Datum van vandaag" just like what you wanted.

    The time is showing properly in other fields as well, it is on 12-hr format. 

    Can you please further explain about the last issue? Thank you.

  • Profile Image

    Answered by MartinSA on May 22, 2015 at 07:18 AM

    Hi Jan,

    The date problem is indeed fixed,

    but time problem is still is as your college Chris mentioned:  I do see the problem with the time data where the 12:00 is converted to 00:00 in your end.



  • Profile Image
    JotForm Support

    Answered by Charlie on May 22, 2015 at 09:58 AM

    Hi,

    I've made a separate thread for the issue regarding the 12:00 being converted to 00:00, as the original issue or concern in this thread has been resolved. Please refer to this link instead: http://www.jotform.com/answers/574493. We will address it shortly.

    Thank you.