How can I change the date format that is inserted into my Google Sheet?

  • ctdstaffing
    Asked on March 15, 2017 at 3:17 PM

    When JotForm updates my Google Sheet it adds the date in this format: 3/10/2017 17:16:02.

    Is there a setting where I can tell it to update the sheet with date only (03/10/2017) and not the time?

    Thanks.

  • David JotForm Support Manager
    Replied on March 15, 2017 at 6:06 PM

    Unfortunately, it is not possible to change the date format that is sent to the spreadsheet:

    How can I change the date format that is inserted into my Google Sheet? Image 1 Screenshot 20

    Let us know if you have another question, we will be glad to assist you.