We have a list view where one of the column shows some date time values. Now the property type is 'Text' for that column. User wants to have sorting functionality (ascending/descending) on that column. Now since the property type is 'Text' for that column, sorting is not working as expected for that column.
The values for this column comes from a service (external system) in text/string format - like 'Fri Dec 06 07:32:39 EST 2013'.
Any idea/suggestion on how to make this list view column sorting work properly (based on date time) will be really helpful.
Share this page
Posted: 7 years ago
Posted: 29 Jun 2016 10:51 EDT
Andrew Fontenelle (fonta)
Sr. Manager, Regional Tech Enablement Delivery - EMEA
Thanks Abhijith, I have similar requirement that a 'Text' property is holding 'Date' values and now in the report user expects to see the 'Date' property to select the options. Could you please suggest anything.
Are you able to convert the String in the format of "Fri Dec 06 07:32:39 EST 2013 - Text" to "20160414T043628.000 GMT -DateTime" using some function? Can you please let me know how you have achieved it?
Posted: 6 years ago
Posted: 29 Jun 2017 14:01 EDT
Bindu Saraf (BinduSaraf)
Principal Cloud Development Engineer, Management Plane Services