Filtering data by today's date

[mkankatala (Mahesh Kankatala)]

Hi @mpearson9526

Do you want to use the filter with excel activities or you can read the excel to a datatable and filter.

Give me a clarification on this…

If you want to filter after converting to a datatable then you can use the LINQ Expressions,
→ Use the Read range workbook activity to read the excel and store in a datatable called dt.
→ Then use the assign activity to write the LINQ Expression,

Below query is for Dates are behind and equal to Today's date
- Assign -> dt = (From row In dt
                  Where CDate(row("Due date").toString)<=DateTime.Now
                  Select row
                    	).Copytodatatable()

Below query is for Dates are behind to Todays' date only,
- Assign -> dt = (From row In dt
                  Where CDate(row("Due date").toString)<DateTime.Now
                  Select row
                    	).Copytodatatable()

→ Then use the write range workbook activity to write the dt to the excel.

Check the below workflow image for better understanding,

Hope it helps!!