Solved
Forum Discussion
The second argument to parse is the format that the string is expected to be in and that’s why you get the 0006-04-18 result.
Here’s an example pipeline to try out. It includes a mapper with the expression @bojanvelevski mentioned and also another method using the Date Time Extractor snap from the ML Data Preparation snap pack.
date-example_2021_04_09.slp (7.0 KB)
Can you please elaborate what you are trying to achieve here