Exporting Dates to Google Sheet has the wrong century

TCJ

Hello , I exported my entire portfolio of project dates to Google sheets. For some reason, all dates after 2030 defaulted to 1930 in Google sheets, whereas anything before that was correct. Does anyone have any suggestions?

jmyzk_cloudsmart_jp

@TCJ

I was not able to reproduce your problem.

TCJ

I was able to resolve this. I was exporting from a Control Center created Summary Sheet. The format of the columns in the Summary Sheet was text, not date. Changing the format to Date fixed the problem. Thanks for looking at this anyway