Does anybody know how to simple way how to extract data table items from the table that was read from Excel file?
In my case, there is 3 column in a Excel, ID, Name and DateTime, for example. And when I read it with Read-range activity, all data will be read as String format and I cannot use Datatable.select activity with date time fo-rmat. (Like Datetime < now() - 1 day.)
Indeed, it is able to separate data if I use for each row and convert string to Datetime format but I think it might be poor performance…
So, if anybody know good way to select data table with date time format, please kindly let me know.