# Date bug - 1 day off

**URL:** https://community.glideapps.com/t/date-bug-1-day-off/72447
**Category:** Ask for Help
**Created:** [April 10, 2024, 6:54am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447 "2024-04-10T06:54:49Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)
#### Post date: [April 10, 2024, 6:54am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/1 "2024-04-10T06:54:49Z")

</div>

Hello,

I have a birthday column but for some reason it’s showing the date 1 day off the actual date. I can see the actual date by clicking inside the cell, but when I click out and on the app, the date is 1 day less. I am attaching screenshots. By the way, it doesn’t matter if I turn time zone on or off. Any help is appreciated.  
 ![Screenshot 2024-04-10 at 2.50.43 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/affa338e1430efaf99b26a83a2dba86fe666fb1f.png)  
 ![Screenshot 2024-04-10 at 2.50.35 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80d2db09264ed09b4e08c37085b37517ebbc89c4.png)

---

<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: [April 10, 2024, 7:01am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/2 "2024-04-10T07:01:16Z")

</div>

Which data source are you using, and how is the date value added?

---

<div class="post-metadata">

### Author: ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)
#### Post date: [April 10, 2024, 7:10am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/3 "2024-04-10T07:10:32Z")

</div>

Using glide data, imported from CSV. Thanks @Darren_Murphy

---

<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: [April 10, 2024, 7:18am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/4 "2024-04-10T07:18:57Z")

</div>

arrr, okay.

I believe there are some issues with the CSV import function. In fact I have an open ticket with Glide support after several issues I ran into with exporting data from one App and importing into another.

What does the data look like in the exported CSV file? If you open it in a text editor, how do the dates appear?

---

<div class="post-metadata">

### Author: ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)
#### Post date: [April 10, 2024, 7:26am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/5 "2024-04-10T07:26:21Z")

</div>

Actually I imported it from Excel, I first exported from google sheets, I am attaching how it looks like in both. The thing is that I see the correct date when I click inside the cell, so the date is correct.  
 ![Screenshot 2024-04-10 at 3.24.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/65850fd5b60f78c2863092a297324c4d4663460d.png)  
 ![Screenshot 2024-04-10 at 3.24.08 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c7619151780461480ca62a35f103a0af17691d4.png)

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [April 10, 2024, 7:38am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/6 "2024-04-10T07:38:40Z")

</div>

I experienced something similar, but I’m not sure if this is the cause. I suspect it’s due to the format in Glide using 12:00 am, while another source uses the format 00:00. Try using the date and time format, it might help you see the problem.

---

<div class="post-metadata">

### Author: ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)
#### Post date: [April 10, 2024, 7:44am UTC](https://community.glideapps.com/t/date-bug-1-day-off/72447/7 "2024-04-10T07:44:29Z")

</div>

Thanks @himaladin the date format doesn’t seem to make a difference. For now I use the math column and added 1 to the date…does the trick.