# Sorting order incorrect

**URL:** <https://community.glideapps.com/t/sorting-order-incorrect/19275>\
**Category:** Ask for Help\
**Created:** [December 2, 2020, 1:54pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275 "2020-12-02T13:54:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [December 2, 2020, 1:54pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275/1 "2020-12-02T13:54:04Z")

</div>

![GLIDE DATE](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/4663ca640e0ef8114dc79daa5a89a78d7699a938.png)  
I have tried all the date formats in google sheet, still the sorting is not correct.  
Please help.  
Jay

---

<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:** [December 2, 2020, 2:24pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275/2 "2020-12-02T14:24:45Z")

</div>

Why do you have a “:” in before the year?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 2, 2020, 3:11pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275/3 "2020-12-02T15:11:01Z")

</div>

Is your sort date the same as the date you are showing in your list?

---

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [December 2, 2020, 3:52pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275/4 "2020-12-02T15:52:50Z")

</div>

Oops !!! thanks for notifying it.

---

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [December 2, 2020, 3:56pm UTC](https://community.glideapps.com/t/sorting-order-incorrect/19275/5 "2020-12-02T15:56:51Z")

</div>

Yes, sort date is the same given in sort. I think I am able to solve the problem by creating rollup column in the data model. That is working fine.

Anyways thanks.

 ![GLIDE DATE 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bb8cd5a70b4646eb3aed79f6bcc5c42ac21a976.png)