Cannot format date correctly to YYYY-MM-DD
Hi there,
I’ve looked at other articles addressing this but non has helped me so far.
Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD.
The date will always be populated.
I’ve trie...
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)
How do I open the sample pipeline in Snaplogic? The file downloads to my desktop and cannot find the appropriate application to open it. I’m a newbie with SnapLogic so still trying to find my feet.
You should use import option from designer to import this sample pipeline directly to your Snaplogic.
Click on “Import a Pipeline” button, and then open/select the appropriate sample pipeline that you want to import.
Regards,
Spiro TaleskiThank you Spiro, found it
