https://community.blueprism.com/t5/Product-Forum/Columns-to-Date-Utility-Collection-Manipulation/m-p/70465#M23070 Does anyone knows how to use "Columns to Date - Utility Collection Manipulation".   I want to sort a collection with fields "Effective Date" and "Values" in ascending order of "effective date" field. However since the effective date type is a text, I cannot do it.   Tue, 20 Feb 2018 10:29:00 GMT HarjyotMalik 2018-02-20T10:29:00Z https://community.blueprism.com/t5/Product-Forum/Columns-to-Date-Utility-Collection-Manipulation/m-p/70465#M23070 Does anyone knows how to use "Columns to Date - Utility Collection Manipulation".   I want to sort a collection with fields "Effective Date" and "Values" in ascending order of "effective date" field. However since the effective date type is a text, I cannot do it.   Tue, 20 Feb 2018 10:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Columns-to-Date-Utility-Collection-Manipulation/m-p/70465#M23070 HarjyotMalik 2018-02-20T10:29:00Z https://community.blueprism.com/t5/Product-Forum/Columns-to-Date-Utility-Collection-Manipulation/m-p/70466#M23071 It sounds like you are using a modified version, I don't think the official Utility - Collection Manipulation object contains such an action. If the data text is not in a sortable format like 20180220, then you will either need to change the format somehow, or maybe append a temporary date column and sort on that. Tue, 20 Feb 2018 14:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Columns-to-Date-Utility-Collection-Manipulation/m-p/70466#M23071 John__Carter 2018-02-20T14:18:00Z