Whenever i scrape any table from webpages, all the columns of the Datatable are of datatype string.
Now, Even the table contains Date or Datetime as one of the columns.
So how can i directly convert the Datatype of these date or datetime columns to datetime within the ExtractedDataTable.
I need to Filter the records based on date condition, like take only records which are created 7 or less days ago.
So if I need to filter the data, I can’t simple filter based on string as the string comparison with date is not consistent as well as Filtered data is not correct many time.
WorkAround I tried: Created a New Datatable (FinalDT) using Build DataTable with the column datatypes i need.
use a for Each activity and loop through the Extracted Datatable.
use an Add Data Row activity to add data into a FinalDT, use ExtractedDatatable row values and Convert the String values to Datatime.
Use Filter Datatable activity to filter the data from FinalDT based on date conditions.
Use FinalDT records to loop through further activities.
Any other option or direct conversion or workaround, please share it with me as its a long process and needs a lot of coding.
Waiting for your responses on the same.