- Filter the records where Status is ‘Open’ ;
- Filter the records where Description is ‘Verify Account Position’ ;
- Filter the records where Date is older than ‘1st of December 2017’ (discard newer records);
- Append the resulting datatable into an Excel worksheet, you shouldn’t worry about the headers and format of the output file.
Filter datatable with all the conditions and Append range activity can be used to the Excel.
If the Column Date is of type Datetime /date . You can continue with Filter. If not Convert the Same to Required data type .
how to convert date of 2018-10-26 this type
Convert.toDatetime(date column value).tostring(“yyyy-MM-dd”)