Date fields behaving oddly when importing from CSV

Hello! I’m currently importing a CSV file into my Glide table.

The date being imported in (raw text, looking at the CSV) is 9/5/2024 2:31:00 PM.

It imports in as 9/5/2024 9:31:00 PM, but when I select the cell, I see that the actual value is 2:31PM. If I copy and paste the cell, and delete the value, re-paste, it shows as 2:31PM…

The field has “Respect Time Zones” unchecked.

Would appreciate any help!

This is a known issue. Convert the CSV to ODS format before importing and it should import correctly.

1 Like