Convert column date with multiple formats

Question

Hello,

I have a dataset with multiple date formats. I need to transform them into yyyy-mm-dd

I created a lookup table with all possible months abreviations that I'm using as to apply as "vlookup".

Date15/07/2021JUL', '07,', '2021'2021-07-01Čtvrtek 8. Dub 2021 4:11 odp. GMT+02:0004/jun/2101.07.2021'02.07.2021'['6', 'JUL', '2021']27.6.202101.07.202128. 6. 20214.1.2021  28 JUL 2021

Can you please help to standardize this?

Treyson · Answer

Also, here is some reading to help you understand what is happening here:

on batch macros:

https://community.alteryx.com/t5/Engine-Works/Batches-Be-Solvin/ba-p/444205

date time formats in Alteryx:

https://help.alteryx.com/20213/designer/datetime-functions

Treyson · Answer

Alright. I think I have a solution for you, but it will require some work on your side.

I have attached a workflow with a batch macro that I created for you. Essentially what the macro is doing is processing your data one time for each format that is in a list of date formats (which I hardcoded in there based on the examples). Records that don't process don't pass through the workflow. I left a record ID field in there so you can notice that almost everything went through the process. The only one I can't figure out is this format (Čtvrtek 8. Dub 2021 4:11 odp. GMT+02:00).

Let me know if you have any other questions about this.

Dynamic Date Formats.yxzp