How to convert date from general format to DateTime format

[rahamtullah (Mohammed Rahamtullah)]

Hi Tanvi,

Below thread might help you with your requirement.

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…

Regards,
Rahamtullah