Excel Submission: when downloading submission any blank Birth Date Picker is downloaded with the current date.

  • Profile Image
    Asked on February 18, 2018 at 10:41 PM

    Hi Guys,

    This form takes athlete's name and date of birth for a team list. 

    When I download the submissions to excel, any blank date of births are populated with the current date.   This does not happen when downloading to csv. 

    The field is a widget called "Birth Date Picker"  there is no option for a default value.

    I have screen shots of jotform display, excel and csv downloads.

    I am able to work around this so I do not need a solution right now.  Just don't want any data in the future to do this.

    Jill Kelly

  • Profile Image
    Answered on February 19, 2018 at 06:49 AM

    Before escalating this to our developers can you please inform on which format is suiting your needs? Do you need the current date on CSV files, or you want to remove that from excel?

    Please let us know so we can proceed. Thank you!

  • Profile Image
    Answered on February 19, 2018 at 07:36 PM

    Hi Ardian_L,

    Interesting question.  I guess, because I mentioned there was no default option, I was looking for one.  But no, I am not after a default date. 

    I simply want, what shows up on the jotform submissions page to show up in the data file.  The submission page (first screen shot) has an empty field for missing dates, so the data should have an empty field as well, yes?


  • Profile Image
    Answered on February 19, 2018 at 10:38 PM

    I have forwarded this issue to our back-end team. You will be updated via this thread when the issue gets fixed.