Filter DataTable by current week

Help
1

I have an excel/csv file that has alot of rows with information entered by date. (MM/DD/YY - format) I’d like my robot to filter data table and use only entries in the current week, i.e. from Saturday (4/7/19) to Friday (4/12/19). Is there anyway the filter data table activity can do that? thanks.

image

2

Hi @tagmct,

Use below code

Dt.select("Date>='4/7/2019' and Date<='4/12/2019'").CopyToDataTable()

Regards,
Arivu

2 Likes