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

    Reports: set date to dd/mm/yyyy format

    Asked by Ian75 on September 21, 2014 at 01:56 PM

    Is there a way to generate reports that use the usual dd/mm/yyyy format, as used by 90% of the world? I don't see any way of doing this.


    Thanks. 

    Reports date format reports date date formatting
  • Profile Image

    Answered by Ben on September 21, 2014 at 05:12 PM

    Hi,

    Are you referring to the Excel reports?

    If so there is an easy way to change the format to the format of your choice, such as dd/mm/yyyy, but not before any submissions are received, but instead once you download it.

    To do that you should open the report and select the column of your choice (the one that holds the date values) and change the format.

    I will show you how to change the format in Libre Office and in Google Spreadsheet.

    Google Spreadsheets

    Libre Calc

    If you are using OpenOffice or MS Office Spreadsheet the functionality and the location where you can apply these changes is quite similar to the above.

    Do let us know if you need any further assistance with this.

    Best Regards,
    Ben

  • Profile Image

    Answered by Ian75 on September 24, 2014 at 04:39 PM

    Thanks for your quick and helpful answer Ben. I have integrated my Jotform with Google Sheets. I did as you suggested to change the date. The problem is that every time Jotform updates Google Sheets, it changes it back to mm/dd/yyyy. Is it possible to set Jotform itself to dd/mm/yyyy?  

  • Profile Image
    JotForm Support

    Answered by KadeJM on September 24, 2014 at 04:58 PM

    As far as I know the custom date in google spreadsheets should stick and take over.

    Can you try generating a new spreadsheet and reapplying it to see if it will work after that?

     

     

  • Profile Image

    Answered by yfaber on July 08, 2015 at 12:38 PM

    I'm having a similar problem, however when my customer inputs "numbers" and submits the form, jotform changes it to date instead of just saving as "number".