ERROR data import: Process failed: Invalid format: "2023-05-31T12:45:22.576+0060" is malformed at "+0060"

Support - Assistance technique
1

Hi everyone.

I am getting this error when I import data: Process failed: Invalid format: “2023-05-31T12:45:22.576+0060” is malformed at “+0060”

This is the lastupdated column in the CSV file

image
image1152×126 12.2 KB

Thanks

2

Hi @ferdinandmussavene

Is it possible that the format of the date time above is changed to YYYY-MM-DD-HH-MM without the time zone and seconds?

To change the format of a column from time zone to the format above, here are instructions for doing so on Google Sheets (sheets.google.com): Format numbers in a spreadsheet - Computer - Google Docs Editors Help

Thanks!