Filter datatable on date


I have date in variable1=01/11/2019 and having excel columnname val = 01/11/2019. I have applied the filter on datatable using select method but it is throwing error. How to apply filter on excel col where excel col need to filtered with date which stored in variable1

try creating a datetime variable and pass it in filter datatable activity instead of string value.

1 Like

Hi @Shirish

See these threads


1 Like


You can use Filter DataTable activity with a datetime variable created as per the attached xaml.
FilterExcelByDateCol.xaml (6.4 KB)

1 Like