cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to use ToDate in Filter Collection

ParnabSinha_Cho
Level 5
Hi,

I am reading a CSV file to collection where column "Entry Date" is in the format January 5, 2021 . 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?

Object - Utility - Collection Manipulation
Action - Filter Collection

Filter "ToDate([Entry Date]) > '2021-00-01'"
Parnab Sinha Choudhury RPA Developer / Business Analyst
1 REPLY 1

EmersonF
MVP
Hi, @ParnabSinha_Cho  try it:
"[Entry Date] > '2021-01-01'"
Filter:
36351.png

This work for me!​

Before filter:
36352.png

After Filter:
36353.png
Sr Cons at Avanade Brazil