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

    Import App: How should I format a date

    Asked by yourhuntingapp on July 20, 2016 at 10:09 PM
  • Profile Image
    JotForm Support

    Answered by liyam on July 20, 2016 at 11:19 PM

    Hello yourhuntingapp,

    You can format a date on how you think it is convenient for you. Do you have a specific concern or purpose for this?

    Looking forward to your response.

  • Profile Image

    Answered by yourhuntingapp on July 21, 2016 at 10:45 AM
    I am importing my data from an excel file. I have modified the cell format to be a date and when I import the data it just shows up as numbers. It does not keep the date format.
    Clint McDonald
  • Profile Image
    JotForm Support

    Answered by Kevin_G on July 21, 2016 at 12:13 PM

    You should right click on the cell you want to format then click on the option "Format Cells", you should get a window like the one below, there you should select "Text" and click OK: 

    Then in your Excel file you should add the date with these two different formats: 

    1. 07-21-2016

    2. 2016-12-12

    This should be the result: 

    Hope this helps.