Converting string to date

jrtomici · January 2023

Hi,

I know there's a STR_TO_DATE function but maybe I could use more insight because it's not working. I have a date field that looks like this:

8-1-22

I want to convert this to a date. How can I achieve this with a ETL formula tile? Thank you.

GrantSmith · January 2023

You need to pass in the correct format string when converting your string to a date

STR_TO_DATE(`date`, '%c-%e-%y')

GrantSmith · January 2023

You need to pass in the correct format string when converting your string to a date

STR_TO_DATE(`date`, '%c-%e-%y')

jrtomici · January 2023

Great, thank you!

Best Answer