17-02-22 06:51 AM
Answered! Go to Answer.
25-03-22 04:31 PM
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,