Editable DateTime with current time as default field does not match the date and time of submission

  • tplink_ar
    Asked on July 7, 2015 at 5:13 PM

    We have a custom form, used to open and close support tickets. But we see in the reports (like Excel or Jotforms Analytics) that don´t match the real time or with the Submission Date in the reports, or closing time in the form. We were observing, the time when starting the form and when is closing, and the mostly cases is mismatch. Could be a bug or maybe we have some wrong done in the form ?

    for example :

    Submission Date Ticket  Closing case
    2015-07-07 15:42:30  2447 07-07-2015 16:19:22
    2015-07-07 15:41:25 2446 07-07-2015 16:25:56
    2015-07-07 15:19:18 2445 07-07-2015 14:05:05
    2015-07-07 15:13:34 2444 07-07-2015 16:24:51

     

    Underlined when mismatched

     

    Thanks for your help.

    Jotform Thread 605085 Screenshot
  • Ben
    Replied on July 7, 2015 at 6:23 PM

    I took a look at your jotform and from what I can see the "Cierre del caso" DateTime field is the only one to capture the date and time, but it is set to allow the time and date to be changed by the user filling out the form.

    This means that they could set it up to show any time they wish.

    Also, please do note that this will also load with the current time of the person opening the form, while the submission date is based on the time of our server, so it might be different depending on where the people submitting the form are based in.

  • tplink_ar
    Replied on July 8, 2015 at 9:40 AM

    Thanks for your answer. Is possible can tuning the submission date according the based in the country, for example? or is automatic from the  server ? thanks

  • Ben
    Replied on July 8, 2015 at 11:22 AM

    The submission Date is default to the server location, but you can set your time zone in your account, which should impact what time is shown as the time of submission.

    You can do that by going to your Account -> Settings -> Timezone

    Editable DateTime with current time as default field does not match the date and time of submission Image 1 Screenshot 20

    Do let us know if that helps and if you have any issues setting it all up and we would be happy to assist.