Change the date format

[HULK]

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

[Felipe_Ribeir0]

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.

[Emmanuel_G]

@HULK 

In attachement the way of doing that.

[MichelleL]

Hi @HULK  - You could also tackle this with the DateTime parse tool.  Sample attached :-)

[Felipe_Ribeir0]

Hi @HULK 

It worked?