# Date problem

**URL:** https://community.glideapps.com/t/date-problem/63822
**Category:** Ask for Help
**Created:** [July 12, 2023, 2:03pm UTC](https://community.glideapps.com/t/date-problem/63822 "2023-07-12T14:03:38Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Nilgul\_Bozkurt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nilgul_bozkurt/32/35023_2.png) [@Nilgul\_Bozkurt](https://community.glideapps.com/u/Nilgul_Bozkurt)
#### Post date: [July 12, 2023, 2:03pm UTC](https://community.glideapps.com/t/date-problem/63822/1 "2023-07-12T14:03:39Z")

</div>

I’m having a problem with dates. help me please  
 ![Screenshot 2023-07-12 155446](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/175a21f550e1fdfea67de85c514728e1174913b7.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: [July 12, 2023, 2:05pm UTC](https://community.glideapps.com/t/date-problem/63822/2 "2023-07-12T14:05:59Z")

</div>

Can you explain the problem please?  
What are you trying to do, and what is not working as you expect?

---

<div class="post-metadata">

### Author: ![Nilgul\_Bozkurt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nilgul_bozkurt/32/35023_2.png) [@Nilgul\_Bozkurt](https://community.glideapps.com/u/Nilgul_Bozkurt)
#### Post date: [July 13, 2023, 8:55am UTC](https://community.glideapps.com/t/date-problem/63822/3 "2023-07-13T08:55:21Z")

</div>

I will try to explain right away. I took my data from google sheet and transferred it to big data table, but when transferring the date, it is transferred according to the American date order, that is, in the form of month, day and year. But I don’t want that. It shows July 12 as December 7. And it does it in deadlines. This is too risky for my projects.

---

<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: [July 13, 2023, 9:29am UTC](https://community.glideapps.com/t/date-problem/63822/4 "2023-07-13T09:29:40Z")

</div>

How did you import the data?  
Did you copy/paste, or did you import as CSV?

Either way, my suggestion would be to reformat your dates as YYYY-MM-DD _before_ you import. If you do that, Glide should get the dates correct.

---

<div class="post-metadata">

### Author: ![Nilgul\_Bozkurt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nilgul_bozkurt/32/35023_2.png) [@Nilgul\_Bozkurt](https://community.glideapps.com/u/Nilgul_Bozkurt)
#### Post date: [July 13, 2023, 9:38am UTC](https://community.glideapps.com/t/date-problem/63822/5 "2023-07-13T09:38:20Z")

</div>

Thank you, I got it as csv. Then I set it according to the American time format in the excel file. It’s fixed for me since Glide has already moved places.