# Date fields behaving oddly when importing from CSV

**URL:** <https://community.glideapps.com/t/date-fields-behaving-oddly-when-importing-from-csv/74487>\
**Category:** Ask for Help\
**Created:** [June 30, 2024, 4:58am UTC](https://community.glideapps.com/t/date-fields-behaving-oddly-when-importing-from-csv/74487 "2024-06-30T04:58:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![felixhu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/felixhu/32/53956_2.png) [@felixhu](https://community.glideapps.com/u/felixhu)\
**Post date:** [June 30, 2024, 4:58am UTC](https://community.glideapps.com/t/date-fields-behaving-oddly-when-importing-from-csv/74487/1 "2024-06-30T04:58:36Z")

</div>

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.

https://www.loom.com/embed/553f67fb844b4b718dd41384b58c8b1d?sid=4590bdfd-6f34-4383-9547-9cc38dc336d3

Would appreciate any help!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 30, 2024, 6:59am UTC](https://community.glideapps.com/t/date-fields-behaving-oddly-when-importing-from-csv/74487/2 "2024-06-30T06:59:11Z")

</div>

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

> **[Having issues importing a CSV file? | Glide Help Center](https://help.glideapps.com/en/articles/9186562-having-issues-importing-a-csv-file)**
>
> CSV Import attempts to auto-type the columns it's importing and sometimes it makes mistakes.