Filter data Help

  • 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”)