8
Hi all,
I have a gallery which I want to sort by dates.
SortByColumns(Filter('Sharepoint List',StartsWith(Title)), "ReviewDate", If(Dropdown_Sort.Selected.Value = "Review Date (Ascending)", Ascending, Descending)
Right now as I have saved the date as text in Sharepoint, it is sorting as such
01/Nov/21
02/Dec/20
03/Mar/21
Instead I want this
02/Dec/20
03/Mar/21
01/Nov/21
How would I do that?
Best
The problem is that you are saving the column as text, so its sorting alphabetically, not by date. You can either change the text to be in the format of yyyy-mm-dd which will sort alphabetically correctly or you can save the date as a date column and sort on that.
Share
Report
All responses (
Answers (
