# 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:** 1

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [August 12, 2021, 12:24pm UTC](https://community.glideapps.com/t/rank-date/30370/1 "2021-08-12T12:24:32Z")

</div>

Here is a rank by date.  
To create the YC compatible table, I had to add a math column to format the date in short format.  
Note that I use in the attached list and divide the \ separator so as not to confuse ‘,’ which separates the date and time  
I also had to use a convertion according to the format of dates by regions. I hope it will work for you 🙂

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

YC link  
[https://Rank-Date.manun2.repl.co](https://Rank-Date.manun2.repl.co)

Source

EDIT V2  
**I found a bug ☹**  
**Uh, well I made a correction not super elegant but obviously it works**

EDIT V3  
I added an exception if the format of the Date array is not compliant (Short Format, Date & Time)

---

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