# Filtering order

**URL:** <https://community.glideapps.com/t/filtering-order/81998>\
**Category:** Ask for Help\
**Created:** [May 23, 2025, 10:37am UTC](https://community.glideapps.com/t/filtering-order/81998 "2025-05-23T10:37:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JackTrowbridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktrowbridge/32/82964_2.png) [@JackTrowbridge](https://community.glideapps.com/u/JackTrowbridge)\
**Post date:** [May 23, 2025, 10:38am UTC](https://community.glideapps.com/t/filtering-order/81998/1 "2025-05-23T10:38:00Z")

</div>

Hello! I’m working on a booking app, and with this I need to filter the bookings.  
However, I can’t seem to order the filter, from closest date or seem to get rid of duplicated dates.

Here are screenshots in what I have so far.

 ![Screenshot 2025-05-23 at 11.36.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57a0527d1e22e8b5fc6ae2b3a3a860f6d0047302.png)  
 ![Screenshot 2025-05-23 at 11.36.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/eee100346d116cb7aa465fedb5a82e77c719593b.png)  
 ![Screenshot 2025-05-23 at 11.36.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80eb1d92ed0da6194828f9e38ee47f293f0558b2.png)

A bit of context, the formatted date text data column was an attempt to get rid of duplicate dates and I believe it worked, however with this I want to have ordered dates from the drop down.

Any help would be highly appreicated, and thank you!

---

<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:** [May 24, 2025, 12:22am UTC](https://community.glideapps.com/t/filtering-order/81998/2 "2025-05-24T00:22:16Z")

</div>

Yeah this is super annoying as they’re treated as text, not timestamps anymore.

Even with just a math column, removing all hours, minutes and seconds from the context, there’s still a milliseconds part of the equation that makes the filter unusable.

---

<div class="post-metadata">

**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\
**Post date:** [May 24, 2025, 4:12pm UTC](https://community.glideapps.com/t/filtering-order/81998/3 "2025-05-24T16:12:55Z")

</div>

Hey Jack!  
To fix the order and remove duplicates from the dropdown:

Remove duplicates: Keep using the `Formatted Date` as it’s working.  
Fix sorting: In the source table, add a **date-only column** (not text), and use that to **sort the list**. Even if the dropdown shows formatted text, it will follow the sort of the original data.

That should give you a clean, ordered list of unique dates!

---

<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:** [May 24, 2025, 11:51pm UTC](https://community.glideapps.com/t/filtering-order/81998/4 "2025-05-24T23:51:47Z")

</div>

> [@Mazen](#):
>
> Fix sorting: In the source table, add a **date-only column** (not text), and use that to **sort the list**. Even if the dropdown shows formatted text, it will follow the sort of the original data.

It’s the built-in filter, I don’t think you can do something like that.