Excel Date (YYYY-MM-DD) to (DD-MM-YYYY)

[Vivek_Arunagiri]

Please check the below post.

How to select data table with date format when I read range to Excel?

Hi all, 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 mi…