Excel Automation/filter data

[UditKhanna]

Hi Community,

There is an excel sheet that i want to automate. There are about 16000 records in a sheet, i want to filter out only those records whose time from current date is more than 30 days. Below is the attached format of login time. Initially, i thought to import all records in a collection and process every record in code stage but that would take a hell lot of time, so there must be some way to achieve this.
Thanks

------------------------------
Udit Khanna
------------------------------

[RonanConsidine]

Hi @UditKhanna,

Apologies for being late to reply to this.

Can I ask why the date is in this format in the first place?​ It would be easier if the system that creates this can present the data in a different way.

Alternatively with some excel rules you can split the data into columns to remove the name of the day and the timestamp so it would go from:

Wed Jan 19 00:45:23 PST 2022

to

Jan 19 2022

This could be used with either an excel rule or a digital worker to convert into a date format much easier with minimal effort.

Best Regards,

------------------------------
Ronan Considine
Business Automation Lead
Blue Prism
------------------------------