Reports: set date to dd/mm/yyyy format

  • Ian75
    Asked on September 21, 2014 at 1: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. 

  • Ben
    Replied on September 21, 2014 at 5: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

    Reports: set date to dd/mm/yyyy format Image 1 Screenshot 80

    Reports: set date to dd/mm/yyyy format Image 2 Screenshot 91

    Reports: set date to dd/mm/yyyy format Image 3 Screenshot 102

    Libre Calc

    Reports: set date to dd/mm/yyyy format Image 4 Screenshot 113

    Reports: set date to dd/mm/yyyy format Image 5 Screenshot 124

    Reports: set date to dd/mm/yyyy format Image 6 Screenshot 135

    Reports: set date to dd/mm/yyyy format Image 7 Screenshot 146

    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

  • Ian75
    Replied on September 24, 2014 at 4: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?  

  • KadeJM
    Replied on September 24, 2014 at 4: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?

     

     

  • yfaber
    Replied on July 8, 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".