After scrapping the datatable from webtable, it may be scrapping date as text (almost all data are scrapped as text using datatscrapping )
so to avoid that do the below steps before using filter datatable activitiy
After scrapping the data from.web using datatscrapping , use excel application scope with write range inside it to write the extracted datatable.
Then after write range use read range activity to read the excel file and tick the preserve format option in the property panel of read range and finally use a varaible dt2 to store the output of read range activity.
After this use filter datatable activity with following parameters
Input Datatable : dt2
Output Datatable : dt2
Column : “Reffered Date”
Value : DateTime.ParseExact(DateTime.Now.ToString("dd MMM yyyy"), "dd MMM yyyy", System.Globalization.CultureInfo.InvariantCulture)