Reports copied to G-Sheet shows dates inaccurately

Hi,

This is more about dates not showing up correctly on G-Sheets,

See 2068183 and 2032023.

For my form 81646514559970 I created a HTML Table report. I used a G-Sheet and import the data. The problem is every date imported is read incorrectly on my G-Sheet. Below is an image of each table comparing the dates and the errors.

What do you think I can do to resolve this problem? I have tried every option on G-Sheet and it still see the dates incorrectly. I have change the settings on my form so that it should be seen correctly. Now I cannot change the tool I use to show dates because I need all this years data to be correct, any change will destroy my numbers.

Now I do have an integration G-Sheet as well, and the dates there are OK. But because I have so many other sheets collecting the data and manipulating it, the update time is very-slow. So, I tried this alternate approach because, as I can see, it far faster.

If I can get the dates to work I'm away to the races. Any ideas?

Best,
  Robert

 Let me run few tests and get back to you with relevant information.

Thank you for your patience.

I have tested it by cloning your form and found that there is a formatting problem in the sheet, please follow the screencast to set the common formatting for columns specifically containing Dates.

Note that every new record in the Sheet will be recorded in the new format only.

Let me know if I have misunderstood the question.

We will be waiting for your response.

Hi,

I had to create a new integration and set the form date fields and on the G-sheet to match. Now at least the integration is working perfectly. I have also eliminated a number of transfers now only one. I'am waiting for the manager to verify the numbers now. 

For now anyway I'am not going to concern my self with the report dates match with the sheet. I will look at this in  the new year... stand by...

Thank you, Robert

Feel free to reach us in case you need any further help from our end.