Excel Report: Does the date field export in the same format it is set up in the form?

  • iconadmin
    Asked on November 2, 2016 at 2:21 PM

    I export the data for a calendar I'm using to an excel spreadsheet and need to do a count formula based on the date.  the formatting in jotform is not consistent with excel.  ie: jotform exports the data for November 8th as 8/11/2016 whereas excel formats it 11/8/2016.  is there a way to change this?  I've tried editing the field and it lets you change the order it is viewed but not how it is exported in excel.

    The form is https://www.jotform.com/?formID=62636755472969

    Please advise if there is a way to correct this

     

    Best,

    Jennifer

  • Kevin Support Team Lead
    Replied on November 2, 2016 at 8:35 PM

    I have just tested this on my end and I can see the date field is being submitted in the same format as it is recorded in the submissions page.

    For example, I have set up the date field as shown in the image below: 

    Excel Report: Does the date field export in the same format it is set up in the form?  Image 1 Screenshot 60

    This is how I receive it in my submissions page: 

    Excel Report: Does the date field export in the same format it is set up in the form?  Image 2 Screenshot 71

    And the format keeps in the Excel report: 

    Excel Report: Does the date field export in the same format it is set up in the form?  Image 3 Screenshot 82

    I have also checked your form and I can see the same behavior, the date field is set up with the format you need and when I submitted a test and downloaded the report I can see the format is the same (dd/mm/yyyy). 

    Here is what I can see in your submissions page: 

    Excel Report: Does the date field export in the same format it is set up in the form?  Image 4 Screenshot 93

    This is what I can se when downloaded the report for your submissions: 

    Excel Report: Does the date field export in the same format it is set up in the form?  Image 5 Screenshot 104

    Could you please share us a screenshot about how the report is being downloaded on your end? 

    Here is also my testing form so you can clone it and find how the date field is being downloaded in the Excel file: https://form.jotform.com/60129158706961