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

    How do I get the year from filled date?

    Asked by yfreib on March 19, 2015 at 07:55 PM

    How do I get out of date only the year?

    For example - filled Date 13/19/1975

    --> Year: 1975

    Thank you very much


  • Profile Image

    Answered by raul on March 20, 2015 at 12:06 AM

    I'm sorry, but I'm not clear about what you want to do.
    Are you referring to the submission date? If so, where would want to use only the year? In another field of the form? Or?

    Please provide us more details about what you want to accomplish so we can provide proper assistance.
    Thank you.

  • Profile Image

    Answered by yfreib on March 20, 2015 at 04:13 AM

    I have to merge  data from the form into a text file, and want  to display in the text the date of birth, and also - the year of birth.

    I want to get the two informations from one question - date of birth

    I have a mistkae in the example above...  

    user insert his date of birth  13/09/1975

    in merging text is shown:

    birthday 13/09/1975

    year of birth 1975


    (sorry... I'm not an English speaker)

    Thank you



  • Profile Image

    Answered by raul on March 20, 2015 at 09:34 AM

    How are you planning to extract the submitted data to generate your file?

    If you're going to export your submissions to an Excel file then you would be able to extract the year from the date of birth using the year function.

    If not, please let us know how are you going to merge your data to see another option that can be used to accomplish what you want to do.

    Thank you.