Posted: 29 Jun 2016 8:47 EDT Last activity: 29 Jun 2017 14:01 EDT
Conversion from String type to Date Time property type
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
Moderation Team has archived post,
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 5 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: 4 years ago
Posted: 29 Jun 2017 14:01 EDT
Bindu Saraf (BinduSaraf)
Senior Cloud Development Engineer, Management Plane Services