How can i convert different date format in one consistent date format?

[B_bhatta]

My file has two date formats i.e. dd-mm-yyyy &  mm/dd/yyyy hours:mins:secs. Can you please advise how can i convert these dates into an mm/dd/yyyy format. Attaching the current file for reference.

[JosephSerpis · Accepted solution]

Hi @B_bhatta I mocked up a workflow let me know what you think?

[atcodedog05 · Accepted solution]

Hi @B_bhatta 

Here is a workflow for the task.

Output:

Workflow:

Add new format here:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[B_bhatta]

Thanks a lot @JosephSerpis for the workflow. It worked 

[B_bhatta]

Hi @atcodedog05,

This solution also worked me. Thanks 😀

[atcodedog05]

Happy to help 🙂 @B_bhatta 

Cheers and Happy Analyzing 😀