Hello Team,
In my excel file there is a column which has date format as 08/31/2022 07:34:09 PM.615 however I need to convert the same to format and viewed as 20223108, please help me by which tools to use and what formula to use
Thanks
Hi @HULK
One way of doing this, take a look at the attached workflow.
If the provided answer helped you to solve the problem/was correct, please accept it as a solution
Thanks.
@HULK
In attachement the way of doing that.
Hi @HULK - You could also tackle this with the DateTime parse tool. Sample attached :-)
It worked?