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

    Date and Time Values are Shown Like Text on Google Spreadsheet Document

    Asked by glidetalk on January 14, 2016 at 04:30 AM

    I have a form that includes the standard date/time picker with the format set to ddmmyyyy.

    when passing it to google sheets (into a date formatted column) the value appears with a ' in front of the date so it's treated as text rather than a date.

    Any idea why?


  • Profile Image
    JotForm Developer

    Answered by mert on January 14, 2016 at 10:53 AM

    Hi there,

    I tried the clone of your form on "Google Spreadsheet" and didn't find anything like " ' " in front of the "DateTime" field value. Please, see it from the below:


    Also, you can re-format the column by using the following guide:



    If you refer something else or need more information, please let us know.