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

    Formatting submission date format

    Asked by canefe on September 15, 2014 at 07:27 AM



    How can i get submission date like this format =2014-04-22 14:54:51



  • Profile Image

    Answered by Ben on September 15, 2014 at 10:00 AM

    Hi Canefe,

    Can you please tell me where you would like to format this date?

    The required parameters would be YYYY-MM-DD HH:MM:SS to display the date in the format you have shown above.

    If you are using spreadsheet, such as Libre Calc you can do that by following these steps:

    Select the date column

    Right click on the column header and select Format Cells...

    On this new window go a bit down to the field marked as: "Format Code" and past the formatting code from above: YYYY-MM-DD HH:MM:SS

    Now click OK and your fields should now be formatted correctly :)


    It is very similar in Google docs as well:

    Mark the column with the dates:

    Make sure that there is a space after day and you will need to click on those arrows on the right of the hour/minute/second to select if you want the 0 in front to be shown or not ie (2:2:13 or 02:02:13). If it does not allow you to click on it to add the text, just click where there is already some text and hit right or left arrow until you get to the point where you want to add any characters.

    I hope that this helps you, but do let us know if you have any questions or if this was not what you had in mind.

    Best Regards,