Hello,
I'm working in Magic ETL.
I have two problems
1 I have a Hire Date field with a string data type that has the string in 2 different formats
01/01/19 or 01/01/2019 How can I convert the values to one format?
2 How can I convert the standardized string to a date. I tried to use str to date but it failed
each time.