Wave connect with google sheets imports year incorrectly

rroy676rroy676 Member Posts: 2

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

Comments

  • JulianPJulianP Administrator Posts: 850 admin

    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!

  • rroy676rroy676 Member Posts: 2

    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

Sign In or Register to comment.