Due to a business requirement, the dates need to be displayed using the following format: DD MMM YYYY HH:MM
Because I am converting modified date to text using the following formula on a calculated column: =TEXT(Modified,"dd mmm yyyy hh:mm"). When I want order the column ascending or descending the result is based on the text and I cannot order by dates any more.
How can I order by modified date when ordering this calculated column?
Ideally I don’t have to have another column with the standard SharePoint modified date column to be able to order by date.
I am using SharePoint 2016 on premise, but I think that the answer would be valid for other versions.
An example would be great. Thanks a lot.