https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48503#M4019 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/2159">@Tejaskumar_Darji</a><BR /><BR />Theres another post similar to this which I think should help you with this issue.<BR /><BR /><A href="https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;MessageKey=d82ef8bb-1539-438e-a088-f742d494ab88&amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01" target="_blank" rel="noopener">Convert Data type of Column Name | Blue Prism Product</A><BR /><BR />Hope this helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />​<BR /><BR />------------------------------<BR />Michael ONeil<BR />Technical Lead developer<BR />NTTData<BR />Europe/London<BR />------------------------------<BR /> Thu, 29 Sep 2022 10:37:00 GMT michaeloneil 2022-09-29T10:37:00Z https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48502#M4018 Hello,<BR /><BR />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.<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="29975.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/30105i234C373E11DB50A4/image-size/large?v=v2&amp;px=999" role="button" title="29975.png" alt="29975.png" /></span><BR /><BR />------------------------------<BR />If I was of assistance, please vote for it to be the "Best Answer".<BR /><BR />Thanks &amp; Regards,<BR />Tejaskumar Darji<BR />Sr. Consultant-Technical Lead<BR />------------------------------<BR /> Thu, 29 Sep 2022 09:40:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48502#M4018 Tejaskumar_Darji 2022-09-29T09:40:00Z https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48503#M4019 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/2159">@Tejaskumar_Darji</a><BR /><BR />Theres another post similar to this which I think should help you with this issue.<BR /><BR /><A href="https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;MessageKey=d82ef8bb-1539-438e-a088-f742d494ab88&amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01" target="_blank" rel="noopener">Convert Data type of Column Name | Blue Prism Product</A><BR /><BR />Hope this helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />​<BR /><BR />------------------------------<BR />Michael ONeil<BR />Technical Lead developer<BR />NTTData<BR />Europe/London<BR />------------------------------<BR /> Thu, 29 Sep 2022 10:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48503#M4019 michaeloneil 2022-09-29T10:37:00Z https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48504#M4020 Thanks for pointing to the respective thread. I'll try to type cast and update here.<BR /><BR />------------------------------<BR />If I was of assistance, please vote for it to be the "Best Answer".<BR /><BR />Thanks &amp; Regards,<BR />Tejaskumar Darji<BR />Sr. Consultant-Technical Lead<BR />------------------------------<BR /> Thu, 29 Sep 2022 12:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Sort-Collection-having-date-and-time-but-in-text-format/m-p/48504#M4020 Tejaskumar_Darji 2022-09-29T12:30:00Z