# Rank Date

**URL:** <https://community.glideapps.com/t/rank-date/30370>\
**Category:** Ask for Help\
**Tags:** custom-code\
**Created:** [August 12, 2021, 12:24pm UTC](https://community.glideapps.com/t/rank-date/30370 "2021-08-12T12:24:32Z")\
**Posts on this page:** 1\
**Showing post:** 38

<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:** [August 14, 2021, 11:31pm UTC](https://community.glideapps.com/t/rank-date/30370/38 "2021-08-14T23:31:38Z")

</div>

Hola @Manu.n

I can see you use the date format _dd/mm/yyyy_ like any person in Latin America. May you test a possible bug I found with this format when anyone tries to write/change the hour in GDE manually?

1)- Create this 2 columns and write these values please

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/05a5714b98bb9753baaf0de6270e1cbb677882d1.png)

1. Later, try to change the time value in any row. I’m going to change the value _12:40:00_ to _1:30:00_  
As you can see, the Date is **03/08/2021** (dd/mm/yyyy) and has to be read as **03 de Agosto de 2021** because my Regional Settings were set to work different to US format.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e30064e34dee6efaa591aa3f1eb951475970ac63.png)

1. but, when the new time value is set, the Month and Day were switched and the new Date is totally wrong!!. Glide thinks that March is August now and many problem begin

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbaa47eaf2768963d3161909c2c9072a9624585b.png)

1. If you change any value (time) again, Glide switches again Month/Day and everything looks fine 🤨  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d80567de6ffb7429803337444e13f7b25d3cece0.png)

To sum up my problem: try to modify a time value manually in GDE when a user has a Date-Time format different to US format can cause problems. The problem begins when Month and Day are \<=12 and are together in the same value.

Can you test and replicate this issue please?

Thanks a lot!

---

_[View the full topic](https://community.glideapps.com/t/rank-date/30370)._