Date upload issues while using Wave Connect from Google Sheet

PratikShah

Hello,

When I am trying to upload Bank transactions through google sheet (Wave connect), the date is getting uploaded incorrectly. E.g. actual transaction date is 02nd September, 2019 but once uploaded, it shows 01st Sep, 2019. This is happening with all the subsequent. (it shows actual date less one day).

Kindly guide.

PaulC

Hello @PratikShah,

Thank you for reporting this.

Could you please tell me:

1. What your time zone is, as set in your computer, and
2. What the time zone set in your Google Sheet is.

The Sheets timezone displays when you go to File > Spreadsheet Settings.

Thank you.

PratikShah

Hi @PaulC ,

thank you for quick revert.
I have set up Indian Standard Time (IST) in Google Sheet and same in my computer.

Kindly advice.

Regards,
Pratik

PaulC

Thank you @PratikShah. This will help us investigate the issue you are experiencing.

For now, if you set the time zone of your Google Sheet (only the Sheet; no need to change anything about the time zone of your computer) to Toronto time, then you should not experience this problem any more.

neverStopLearning

The same happened to me! I even formatted the date so it matched the date formate for the website: YYYY-MM-DD. All my dates was one date off just like you. I had over 700 entries so it took a long long long time to go back and fix it.

Shafii

Yes, I'm also facing same problem. The date become 1 day earlier after uploaded by Googlesheet