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

[panpan1020 (AngPue)]

Hello,

I want to filter an Excel Doc by date, deleting de rows wih more than 30 days old, but the date format is YYYY-mm-dd and i need dd-mm-YYYY because the filter dosn’t work.

What can i Do?

[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…

[panpan1020 (AngPue)]

Many thanks

[Vivek_Arunagiri]

Your welcome.

If you got solution, please mark it as solved.