Discussion
TCS
US
Last activity: 29 Jun 2017 14:01 EDT
Conversion from String type to Date Time property type
Hi,
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.
Thank you.
Kaushik
Pegasystems Inc.
GB
Thank you for your question. We will investigate and someone will contact you with a solution presently.
Regards,
Andrew Fontenelle
PDN and Pega Academy Support Team
Telstra
AU
Convert that date you get from external system into date time and set it to a date time property. Use the date time property in your report.
Property 1: .OriginalDateTimeProperty - Fri Dec 06 07:32:39 EST 2013 - Text
Property 2: .ConvertedDateTimeProperty - 20160414T043628.000 GMT -DateTime
How to convert? You may have to write a function to do this conversion.
You can play with @String.toDateTime("Fri Dec 06 07:32:39 EST 2013"). But, I don't think this will work as your format looks a bit weird.
Incessant Technologies
AU
Accenture
IN
Hi ,
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?
Thanks,
Venkatesh
Pegasystems Inc.
IN
Hi Venkatesh,
You can use the following function @String.toDateTime("Fri Dec 06 07:32:39 EST 2013").
Pegasystems Inc.
US
Great discussion all. In the future, I highly recommend posting similar questions in the new Product Support Community that just went live on the PDN today!
Thanks.
B.