# The date is incorrect after importing data

**URL:** <https://community.glideapps.com/t/the-date-is-incorrect-after-importing-data/79526>\
**Category:** Ask for Help\
**Created:** [January 25, 2025, 5:05pm UTC](https://community.glideapps.com/t/the-date-is-incorrect-after-importing-data/79526 "2025-01-25T17:05:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\
**Post date:** [January 25, 2025, 5:05pm UTC](https://community.glideapps.com/t/the-date-is-incorrect-after-importing-data/79526/1 "2025-01-25T17:05:58Z")

</div>

Hi…  
I have a question. I imported data from Excel, and in my data, the date was January 24, 2025. However, after the import was successful, the date changed to January 23, 2025. I was curious and double-clicked on the date, but after double-clicking, the date became correct again.  
Is there something wrong?

Here’s what it looks like after the import:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bdd404949f395ded5c6a44357dd1c1dd30d37e4.jpeg)

Here, I tried double-clicking on it.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43b70131cddf02e071b3aa099368d2a3f8bfe43c.jpeg)

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [January 25, 2025, 5:57pm UTC](https://community.glideapps.com/t/the-date-is-incorrect-after-importing-data/79526/2 "2025-01-25T17:57:22Z")

</div>

It is probably because of the timezone format.

Check or uncheck the option respect timezone in the column option.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 26, 2025, 12:18am UTC](https://community.glideapps.com/t/the-date-is-incorrect-after-importing-data/79526/3 "2025-01-26T00:18:19Z")

</div>

> [@Big Tables - date/time column offset issue](https://community.glideapps.com/t/big-tables-date-time-column-offset-issue/75513/11):
>
> Well, that response you got from Support is not what I would have expected, so I just did a bit of testing. I created a new table and added some rows via the API, using curl from a terminal. Here are the results: (NB: this was with a regular table. See further below for results with a Big Table.) In the above: The first column is a date/time column with respect time zone enable The second column is a date/time column with respect time zone not enabled …

You should have a read on this excellent test here.