# Bug date sorting **URL:** \ **Category:** Report a Bug\ **Created:** [May 6, 2020, 11:55am UTC](https://community.glideapps.com/t/bug-date-sorting/8573 "2020-05-06T11:55:03Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\ **Post date:** [May 6, 2020, 11:55am UTC](https://community.glideapps.com/t/bug-date-sorting/8573/1 "2020-05-06T11:55:03Z")
Hello, My first bug on Glide ☹ Here is the thing : when I filter the date the order is not good at all and I don’t understand anything about this random order. It happens particularly when I want to have the most recent date on top… Does somebody would know what’s happening ? In the google sheet it works just fine : [https://docs.google.com/spreadsheets/d/1AycsGxTsa7Qta4h6sbma\_Gvihtqydl7mzfi2VsltVcM/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1AycsGxTsa7Qta4h6sbma_Gvihtqydl7mzfi2VsltVcM/edit?usp=sharing) The google sheet is just a test so everybody can play around Thanks for you help Antoine ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8e88840119120745cc95d3dccc660826916325c3.png) My app’s URL: [https://cbs6x.glideapp.io/](https://cbs6x.glideapp.io/) ---
**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:** [May 6, 2020, 12:14pm UTC](https://community.glideapps.com/t/bug-date-sorting/8573/2 "2020-05-06T12:14:08Z")
Have you tried formatting your date data as “mm/dd/yyyy”? ---
**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\ **Post date:** [May 6, 2020, 12:23pm UTC](https://community.glideapps.com/t/bug-date-sorting/8573/3 "2020-05-06T12:23:39Z")
Yes and it works thank you @ThinhDinh ! but is there a way to keep it dd/mm/yyyy and still have it working correcly ? I’m in France and people wont get this mm/dd/yyyy format unfortunately … ---
**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:** [May 6, 2020, 12:52pm UTC](https://community.glideapps.com/t/bug-date-sorting/8573/4 "2020-05-06T12:52:59Z")
Hi Antoine, please check your app again if it correctly displays now. I’m not sure what caused the error, what I did was just extract the day, month, year and then combine them back in again using a DATE formula. Looks like it’s ok now. ---
**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:** [May 6, 2020, 12:53pm UTC](https://community.glideapps.com/t/bug-date-sorting/8573/5 "2020-05-06T12:53:53Z")
yyyy/mm/dd is a safe format internationally. As long a Glide recognizes the column as date, you should be able to set the formatting for the date in the data viewer and it should adjust by user’s country or region. ---
**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\ **Post date:** [May 8, 2020, 6:07am UTC](https://community.glideapps.com/t/bug-date-sorting/8573/6 "2020-05-08T06:07:23Z")
Thanks to both of you for your answers, what worked really well was to configure the column as a date in the Data Panel. It solved the problem, the filter works great new. Thanks @Jeff_Hager