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!
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.
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!
It’s the built-in filter, I don’t think you can do something like that.
