Change of Date format

  • Profile Image
    Asked on February 11, 2020 at 05:41 AM

    Hello.  Please could you advise how the Excel submission date format can be amended?  We changed the forms to dd-mm-yy however, the Excel data is still showing mm-dd-yy.

    Thank you.

  • Profile Image
    Answered on February 11, 2020 at 08:56 AM

    To be able to change the Time format on the submission page, you would be able to change it via the account settings:


    Hope this helps!


  • Profile Image
    Answered on February 11, 2020 at 09:50 AM
    The submission date is correct. On the jotform it’s the Date of Birth I am having problems with. So on jotform a DOB is 06/05/2007 excel down load and it says 05/06/2007 for example. I need to calculate ages in the excel spread sheet which are obviously incorrect.
  • Profile Image
    Answered on February 11, 2020 at 11:14 AM

    Please check my reply on your other thread -