Filter date using IF activity

[Purvai_Marwaha]

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

[Palaniyappan (Palaniyappan P)]

@Purvai_Marwaha

want to do it IF activity.

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

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Cheers @Purvai_Marwaha

[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.

[Palaniyappan (Palaniyappan P)]

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