Filter date using IF activity

I have extracted data in datatable. Now I want to filter data in if condition. How can I filter data havingdate less than 01 December 2019. I want to do it IF activity.

Can someone help me on this

May I know why in specific with IF condition
We can directly do that with SELECT Method
Kindly have a view in this

Cheers @Purvai_Marwaha

I used select and then copied the data to data table. After that when I m writing using write range activity then first column is always coming as blank in Excel and data is starting from secomg column.

1 Like

May I know what is the range mentioned in the WRITE RANGE activity
Make sure it is mentioned as “A1” and enable the ADD HEADERS property in the property panel of Write range activity
Cheers @Purvai_Marwaha