Filter data from datatable on column that has a date value

Help
1

hi , I have extracted data from a website . the data has a column which has date values and I need to filter based on date conditions.

  1. first of all, how do i convert the value in that column to date type ?

sample_xaml.xaml (10.0 KB)
Below is the sample data that has the column name “Ending At” with the date value.
I need to convert this into date and do process.

In my attached workflow file i have provided a filter activity and can filter other columns.

Capture1
Capture1686×671 76.8 KB

2

I’ve made changes to your workflow, but I’m not able to test it since you’ve not added an “Open Browser” with it. Try this updated workflow once and let me know if this solves your problem.

sample_xaml.xaml (12.1 KB)

3

Hi All,

I want to filter dates less than ‘01-12-2017’ from attached excel file. Could you please help me in this.

Regards,
Lakshman.Scrapped data.xlsx (13.3 KB)