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

    Import Data App gives a time difference in Submission Date when imported to Jotform

    Asked by sudsport on September 11, 2015 at 11:38 AM

    Hi,

    When Including 'Submission Date' column in template file for data import the loaded result give a time difference of 6h00 between loaded time and registered time.

    This is probably due to the fact that the loaded date is considered as system time but not local time, as we are based in Paris that make the difference with US Eastern time.

    So if I load 2015-19-11 10:00:00 it will display as submission time 2015-19-11 16:00:00

    Although I can cope with it by fiddling with dates on Excel prior to load it, Is there any plan to fix it?

    Regards,

    Georges

    submission date
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on September 11, 2015 at 04:49 PM

    I guess you are talking about something like this:

    You can set this up through your Account Settings:

     

    This should change the existing submissions date and time to your local time.

  • Profile Image

    Answered by sudsport on September 11, 2015 at 04:59 PM

    Hi Jeannette,

    My account is already set to Paris time and all is working fine for any standard submission but I get this 6 hours difference when doing data import with "created_at" field included in the data set.

    Regards,

    Georges

  • Profile Image
    JotForm Support

    Answered by Welvin on September 12, 2015 at 10:08 AM

    Hi Georges,

    If you will check the "Submission Date", this should match the DateTime field in your CSV or Excel File. If this is unchecked, the date will be based on today's date with your own timezone settings. 

    Do you still have the excel file to import? Can you share us a small part of the data so we can try it to our end? Or, if you can try it again and take a screenshot of the issues, that would be great so we can forward this directly to our developers. 

    I actually tried the import process and it's giving me a correct date:

    Thanks

  • Profile Image

    Answered by sudsport on September 12, 2015 at 04:41 PM

    Hi Welvin,

    I confirm that submission date registered during import process is with a 6 hours offset of the CSV date field (6h because my account is set to Paris Time (GMT+1)).

    Here is some CSV Data:

    created_at,65_Cliquer pour éditer_widget,6_Année de la course_textbox,53_Manifestation_textbox,59_Choisissez votre course_dropdown,54_Dossard_textbox,30_Nom_textbox,31_Prenom_textbox,9_Sexe_radio,23_Jour_dropdown,22_Mois_dropdown,21_Année_dropdown,4_Catégorie_textbox,68_Ecole_radio,69_Course Enfants_textbox,46_Club_textbox,36_Bissextile_textbox,35_Jour 31_textbox,1_Adresse: Pays / Code Postal / Ville_widget,62_Pays/CP/Ville_textbox,37_Email_email,38_Tel_textbox,39_Acceptation conditions générales_checkbox,67_Certif CPSL_textbox,43_Certif_textbox,66_Distance (km)_textbox,44_Mode de paiement_dropdown,63_Orde de Paiement_textbox,45_Paiement_textbox,72_Payé_dropdown,51_Montant_textbox,70_Message validation1_textbox,71_Message validation2_textbox,55_Team CPSL_textbox,61_Cat CPSL_textbox
    2015-09-05 04:09:43,,2015,Les km de Saint-Gély,Courses Enfants,,COSTE,Margaux,F,,,2005,PO,Patus,1500 m,,"1,25",Oui,"Country: France (FR)
    Postal code: 34980
    City: Saint-Gély-du-Fesc","Country: France (FR)
    Postal code: 34980
    City: Saint-Gély-du-Fesc",costesav@free.fr,0650479460,,,Non,"1,5",,Les km de Saint Gély,Gratuit,,0,,,,POF
    2015-09-05 04:23:30,,2015,Les km de Saint-Gély,15 km,,GABELLE,Thibaut,M,,,1978,SE,,,,"1,5",Oui,"Country: France (FR)
    Postal code: 34980
    City: Saint-Gély-du-Fesc","Country: France (FR)
    Postal code: 34980
    City: Saint-Gély-du-Fesc",GABELLE.THIBAUT@GMAIL.COM,0632558933,,,Non,15,Espèces,Les km de Saint Gély,Oui,Oui,9,,,,SEM

    Form where data has been loaded in is http://form.jotformpro.com/form/52536900228958

    Regards,

    Georges

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 13, 2015 at 12:18 PM

    Thanks for providing more details. I was able to reproduce the problem when I set my account to your timezone. There's indeed 6hrs added on the submissions date. The same issue occurs even on my timezone . It simply converts my time into EST time, so 4:00:00 outputs 16:00:00 (12hrs offset).

    I have now raised this to our developers for further investigation and hopefully find a solution. You will be informed here once this is fixed.

    Thanks!