Sort Collection having date and time but in text format

[Tejaskumar_Darji]

Hello,

How can I sort the collection on a date and time column but the data type is text. I tried sort collection but it does not seem to be working in this scenario.



------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

[michaeloneil]

Hi @Tejaskumar_Darji

Theres another post similar to this which I think should help you with this issue.

Convert Data type of Column Name | Blue Prism Product

Hope this helps 🙂
​

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[Tejaskumar_Darji]

Thanks for pointing to the respective thread. I'll try to type cast and update here.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------