Unable to use ToDate in Filter Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-07-21 03:59 PM
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'"
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-07-21 08:44 PM
Hi, @ParnabSinha_Cho try it:
Filter:

This work for me!
Before filter:

After Filter:
"[Entry Date] > '2021-01-01'"
Filter:
This work for me!
Before filter:
After Filter:
Sr Cons at Avanade Brazil
