Google Sheets Integration: Date submissions data in google sheets are in different formats

Hi there,

I have noticed this issue from a long time regarding the results from DATE data fields. See below snapshot.

This greatly affects when we do calculations based on dates (example: number of dates between two days). Can you kindly look into this matter at your earliest convenience?

Below is the form link, But I have noticed this issue in other forms as well.

https://form.jotform.com/241820714136854

Hi Sandun,

Thanks for reaching out to Jotform Support. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience and understanding.

Hi Sandun,

To confirm, have you had instances where you disconnected the Google Sheets Integration, and then added it back? Also, keep in mind that you can manipulate the format of the date on your Submission Table. Let me show you how:

1. On your Submission Table, click on the Three Vertical Dots icon in the Date column.
2. Then, hover your mouse over the Date Format.
3. Finally, select your preferred Date format.

Once we hear back from you, we can move forward with a solution.

Hi Joshua,

Yes, I did connected and disconnected several times. I will ensure the date format is as my preference. I will let you know if the issue persist even after this. Thanks mate.

Cheers

Sandun