How to filter date range and how to retrieve data from the specified column that has been filtered based on the selected columns

[sai.kiran]

Have a look at this on how to work with Date filters

How to Filter Excel Data by Today's Date

Hello, I have not done this using the FilterOptions but you can use an Assign activity to set an array of rows or datatable that meets your criteria. Here’s an example, arrayRows = dt.AsEnumerable().Where(Function(row) cdate(row(“column”).ToString) = Now).ToArray() or dtNew = dt.AsEnumerable().Where(Function(row) cdate(row(“column”).ToString) = Now).CopyToDataTable() The difference of the two examples are that an array of rows let’s you update values and it updates to the original datatabl…