cancel
Showing results for 
Search instead for 
Did you mean: 

Columns to Date - Utility Collection Manipulation

HarjyotMalik
Level 2
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.  
1 REPLY 1

John__Carter
Staff
Staff
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.