# Date format mixed?

**URL:** https://community.glideapps.com/t/date-format-mixed/12858
**Category:** Ask for Help
**Created:** [July 21, 2020, 12:27am UTC](https://community.glideapps.com/t/date-format-mixed/12858 "2020-07-21T00:27:48Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [July 21, 2020, 12:27am UTC](https://community.glideapps.com/t/date-format-mixed/12858/1 "2020-07-21T00:27:48Z")

</div>

I am having an issue with the correct date formatting. I am using European which causes the date comparison not working correctly.

I would like to display all items with date before today as shown in the screenshot. On one it’s working and on the other one not. It’s probably an easy fix, but what should I set as the date format to get this working correctly?

 ![Screenshot](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e4fc014ff002e960fad2e45fcdb108883d8a37a5.png)

---

<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: [July 21, 2020, 12:36am UTC](https://community.glideapps.com/t/date-format-mixed/12858/2 "2020-07-21T00:36:40Z")

</div>

Can you try going into the Data Editor and set a format on the Date column? I think it would honor all the values in that column.

---

<div class="post-metadata">

### Author: ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [July 21, 2020, 12:55am UTC](https://community.glideapps.com/t/date-format-mixed/12858/3 "2020-07-21T00:55:24Z")

</div>

yes, that did the trick! thanks once again!!!