custom delimiter

Hi @Tcole ,

Here you go:

If doing this in beast mode/ SQL:

CONCAT(LEFT(`whatever the date column is named`,4),'-',SUBSTRING('whatever the date column is named',5,2),'-',RIGHT('whatever the column is named',2))

This will just give you a string though. If you need it to be a real date then in the ETL you can do the same formula, but like this:

CAST(CONCAT(LEFT(`whatever the date column is named`,4),'-',SUBSTRING('whatever the date column is named',5,2),'-',RIGHT('whatever the column is named',2)) as date)

OR

DATE(LEFT(`whatever the date column is named`,4), SUBSTRING('whatever the date column is named',5,2), RIGHT('whatever the column is named',2))

How this works is I'm ripping apart the values and putting them back together. So I'm saying "Start from the left and go 4 places…Then start in the middle at place 5 and go two spots.

Hope that helps. I explain that a bit more in this video: https://youtu.be/tqa-ZqewVt0