I have a dropdown filter for Delivered dates on my app that pulls data from a SharePoint list, but for some reason, the dates are been filtered sequentially such as Month first, Day second, and Year last(see screenshot).
I need the dates to be in chronological (Newest to the oldest)
02/11/2023
02/05/2023
01/20/2023
09/01/2021
02/10/2021
here is the code I'm currently using which is creating what you see on the screenshot.
Sort(Distinct('Deliveries Library',Text('Actual Delivery Date',"mm/dd/yyyy")),ThisRecord.Value,SortOrder.Descending)
Any help would be highly appreciated.