https://community.blueprism.com/t5/Product-Forum/Unable-to-use-ToDate-in-Filter-Collection/m-p/99884#M47327 Hi,<BR /><BR />I am reading a CSV file to collection where column "Entry Date" is in the format <STRONG>January 5, 2021&nbsp;</STRONG>. Now I am trying to filter collection based on "Entry Date" go get all rows after January 1, 2021. I am using the ToDate function as this field is a text field. But its throwing an error saying undefined function ToDate. Any help?<BR /><BR />Object - Utility - Collection Manipulation<BR />Action - Filter Collection<BR /><BR />Filter "ToDate([Entry Date]) &gt; '2021-00-01'"<BR /> Mon, 05 Jul 2021 14:59:24 GMT ParnabSinha_Cho 2021-07-05T14:59:24Z https://community.blueprism.com/t5/Product-Forum/Unable-to-use-ToDate-in-Filter-Collection/m-p/99884#M47327 Hi,<BR /><BR />I am reading a CSV file to collection where column "Entry Date" is in the format <STRONG>January 5, 2021&nbsp;</STRONG>. Now I am trying to filter collection based on "Entry Date" go get all rows after January 1, 2021. I am using the ToDate function as this field is a text field. But its throwing an error saying undefined function ToDate. Any help?<BR /><BR />Object - Utility - Collection Manipulation<BR />Action - Filter Collection<BR /><BR />Filter "ToDate([Entry Date]) &gt; '2021-00-01'"<BR /> Mon, 05 Jul 2021 14:59:24 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-use-ToDate-in-Filter-Collection/m-p/99884#M47327 ParnabSinha_Cho 2021-07-05T14:59:24Z https://community.blueprism.com/t5/Product-Forum/Unable-to-use-ToDate-in-Filter-Collection/m-p/99885#M47328 Hi, <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/211">@ParnabSinha_Cho</a>&nbsp; try it:<BR /><CODE>"[Entry Date] &gt; '2021-01-01'"</CODE>​<BR />Filter:<BR /><span class="lia-inline-image-display-wrapper" image-alt="36351.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36361iAEABFF2337F0564E/image-size/large?v=v2&amp;px=999" role="button" title="36351.png" alt="36351.png" /></span><BR /><BR />This work for me!​<BR /><BR /><STRONG>Before filter:</STRONG><BR /><span class="lia-inline-image-display-wrapper" image-alt="36352.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36358iE9C45756CAA5448C/image-size/large?v=v2&amp;px=999" role="button" title="36352.png" alt="36352.png" /></span><BR /><BR /><STRONG>After Filter:</STRONG><BR /><span class="lia-inline-image-display-wrapper" image-alt="36353.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/36359iBE9FBCDC6F2562BD/image-size/large?v=v2&amp;px=999" role="button" title="36353.png" alt="36353.png" /></span> Mon, 05 Jul 2021 19:44:59 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-use-ToDate-in-Filter-Collection/m-p/99885#M47328 EmersonF 2021-07-05T19:44:59Z