Filtering datatable 'DateTime' type using 'xxxx.Select()' method

Hi Automaters,

I’m doing an assignment that requires filtering a datatable & output to excel. In the 1st pic states the requirements & in 2nd pic, I’m using the ‘xxx.Select()’ method, instead of ‘For Each Row’ activity, to do the filtering. I managed to filter the ‘type’ & ‘status’ but not sure how to filter the dates (>1 Jan 2018). Appreciate if anyone can help me out. Thks

Pic 1:

Pic 2

@kelip182 Can you check this post :

Ahh ok. Let me check it out. Thanks

1 Like