# Show filter dropdown - dates - not working **URL:** \ **Category:** Ask for Help\ **Created:** [January 6, 2023, 5:55am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404 "2023-01-06T05:55:45Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [January 6, 2023, 5:55am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/1 "2023-01-06T05:55:45Z")
My filter is a date. I’ve tried many things but can’t get the filter to show the dates in order. Tried all date formats, Short - Long and Luxon… looks like its looking at it as a text. I’ve sorted the tab and the collection by date and the Group also works and sorts correctly… but the filter still not working, any suggestions? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46012f7e4ee9c67156ba3ffb74b8466ae2e9729c.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 6, 2023, 6:01am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/2 "2023-01-06T06:01:36Z")
> [@abdo](#): > > looks like its looking at it as a text. Yes, correct. If you want them to sort as you would expect, then you should use a format that will sort naturally as a string. eg. yyyy-mm-dd ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [January 6, 2023, 6:09am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/3 "2023-01-06T06:09:08Z")
do you have any link to the possible luxon codes to switch the date format? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 6, 2023, 6:13am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/4 "2023-01-06T06:13:46Z")
> **[luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens)** > > Immutable date wrapper yyyy-MM-dd should do it. Just be aware that the Format Date plugin has been known to give inconsistent results. Personally, I don’t use it. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [January 6, 2023, 11:17am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/5 "2023-01-06T11:17:40Z")
Thank you We have been depending a lot on it since December for dates. Haven’t experienced any issues. Good to know it has had some issues, will definitely try to go around it or keep an open eye ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 6, 2023, 11:26am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/6 "2023-01-06T11:26:57Z")
It seems to work perfectly fine for most people most of the time. And even all of the time for some. But I’ve had issues with it in the past, so I don’t trust it. Actually I don’t think it’s the plugin itself, but rather the Luxon library that is a bit buggy. Below is a previous rant I had about it 🙂 > [@Time Format](https://community.glideapps.com/t/time-format/50074/8): > > The other thing you need to do is test it at different times of the year. Early on, when I was trying to use it, I found that it would sometimes get the day and month mixed up, but only under certain circumstances, and only if the date was ambiguous. For example, today is September 25th. In the US, they write that as 9/25/2022. In the real world, we write it as 25/9/2022. But either way, it’s obvious that it’s September 25. It can’t be anything else, because there is no 25th month. But, le… ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 7, 2023, 11:27am UTC](https://community.glideapps.com/t/show-filter-dropdown-dates-not-working/56404/7 "2023-01-07T11:27:38Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.