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.
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?