Filtering order

[JackTrowbridge]

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.

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!

[ThinhDinh]

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.