Wave connect with google sheets imports year incorrectly

rroy676

Hi,

When I try to import data with a 2 digit year date, it imports it as the wrong 4 digit year (ie 21 is imported as 1921 instead of 2021).

Thanks

JulianP

Hey @rroy676 !

Are you referring to your transaction dates perhaps? If so, have you tried entering the full year 2021 (all four digits) as opposed to "21"? This should do the trick. Let me know if that helps!

rroy676

Hi @JulianP

Thanks for your response. When I export the data, it comes out as a 2 digit year. What you suggest means I will have to manipulate the entire list of transactions to make it a 4 digit year. This makes the time saving feature of the importation and will increase the risk of mistakes.

Thank you