# Dd mm yyyy not ordering ok when looking up the latest value

**URL:** <https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066>\
**Category:** Report a Bug\
**Created:** [September 1, 2020, 1:05pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066 "2020-09-01T13:05:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [September 1, 2020, 1:05pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066/1 "2020-09-01T13:05:22Z")

</div>

When I lookup the latest value, it shows the latest according to mm dd yyyy format

 ![Screenshot_2020-09-01-14-58-07-53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/584dafd6b1f1f01ddddcfe9c3e47ad25e8fce447.jpeg)

So in this picture takes 11 06 2020 as the latest , taking it as 6 November instead of 11 June. Others records are depreciated as 6 from months 16 and 22 do not exist.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [September 1, 2020, 1:25pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066/2 "2020-09-01T13:25:49Z")

</div>

Check your GS’s regional settings to verify if it is working with US or Spanish format and let me know.

Saludos

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [September 1, 2020, 2:24pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066/3 "2020-09-01T14:24:08Z")

</div>

Thanks.Spanish.

 ![IMG20200901162234](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0fdddd170e9b1bddff7bb82dab655909f8560ec2.jpeg)

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [September 1, 2020, 2:36pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066/4 "2020-09-01T14:36:12Z")

</div>

Changing date format to date only , works ok  
Previously was date and time

---

<div class="post-metadata">

**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\
**Post date:** [September 1, 2020, 11:48pm UTC](https://community.glideapps.com/t/dd-mm-yyyy-not-ordering-ok-when-looking-up-the-latest-value/15066/5 "2020-09-01T23:48:40Z")

</div>

Date only works, or have an array column, looking into the date and converting it to the spanish format.