When date field is downloaded they show as text fields and not as date field.

  • Profile Image
    outreachtsnw
    Asked on March 01, 2021 at 06:57 PM

    In our New Member 2021 Jotform I used the birthdate and diagnosis dates field and when downloaded they show as text fields and not as date field.

    This is the form:

    https://form.jotform.com/203201557266147


    I thought I used the same field as last year but now it is different. Was there a change made in the field?

    This is last years form:

    https://form.jotform.com/200377285066154


    Thank you!

    Beatriz Palacio



  • Profile Image
    Jed_C
    Answered on March 01, 2021 at 11:08 PM

    when downloaded they show as text fields and not as date field. — May I know how did you download the it? Is it via PDF, CSV or Excel? I've tried cloning your form and the date field is correctly shown when I downloaded it as PDF.

    1614658090_603dba2a7f6c0_490467138141749

    Can you please send us a screenshot so we can see? Looking forward for your response.

  • Profile Image
    teamsurvivornw1
    Answered on March 02, 2021 at 12:22 AM

    I downloaded to Excel. The format is text and I want it as a date.

    Thank you


    1614662452_603dcb340f061_

    1614662471_603dcb47c902a_

  • Profile Image
    jherwin
    Answered on March 02, 2021 at 03:31 AM
  • Profile Image
    teamsurvivornw1
    Answered on March 03, 2021 at 01:11 PM

    I do not want to change the format in Excel every time I download the file. Is there a way to change the field? This did not happen with our Member Form from last year.

    Please advice.

    Thank you,

    Beatriz Palacio

  • Profile Image
    Mike_G
    Answered on March 03, 2021 at 08:10 PM

    We would like to apologize for any inconvenience. I just noticed that on your 2021 TSNW Membership Form (https://form.jotform.com/203201557266147), the date field you used is a Birth Date Picker widget.

    1614817995_60402acbcf98d_zt210303_193049

    While on your last year's form, 2020 TSNW Membership Form: New Members (https://form.jotform.com/200377285066154), you are using the Date Picker field under the Basic Form Elements.

    1614818077_60402b1d09451_zt210303_193410

    I'm afraid that the value the Birth Date Picker widget produces is, by default, a text, and its format can be changed to a date format by updating it manually on the Excel file.