Converting Text To Date When Data Has 2 Different Formats

[fatihsub]

Hi, 

Normally I use DateTime under parse menu to change text formatted date. 

However, I realized that my main data file has different time formats. That is because the main data file is a combination of multiple files which are appended from files coming from multiple sources. Apparently when downloading, some sources formatted date as MM/DD/YYYY while the others are formatted as DD/MM/YYYY. 

Is there an easy way to determine if the file is using MM/DD/YYYY or DD/MM/YYYY before merging them so that the combined file has one standard date format?

Thanks,

Fatih

[BenMoss · Accepted solution]

I would consider using the BB date macro on the Altertx Gallery, it converts multiple date types in the same field and you don't have to specify the structure either.

Link below...

https://community.alteryx.com/t5/Engine-Works-Blog/Introducing-BB-Date-Date-Parsing-for-the-Rest-of-...

Ben

[fatihsub]

Thanks Ben for pointing out the macro. 

That saved me a lot of time!

Fatih