- 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.
Hi @Sana_Afreen,
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”)