โ04-09-2021 05:09 AM
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 tried the following expressions but they wont process correctly
Date.parse($original[โDue Dateโ], โyyyy MM ddโ)
LocalDate.parse($original[โDue Dateโ],โyyyy/MM/ddโ)
If I use the above expression and if the date is 06/04/2021, the output date becomes 0006-04-18. Itโs inexplicable.
โ04-10-2021 01:16 PM
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.
โ04-11-2021 01:11 AM
You should use import option from designer to import this sample pipeline directly to your Snaplogic.
โ04-11-2021 01:27 PM
Click on โImport a Pipelineโ button, and then open/select the appropriate sample pipeline that you want to import.
Regards,
Spiro Taleski
โ04-12-2021 12:39 AM
Thank you Spiro, found it
โ04-12-2021 12:42 AM
Okay so the Date/Time Extractor is not available in our packs which is fine.
Using the expression provided, the date still doesnโt format properly.
The input date is 06/04/2021 but in the expression appears as 0021-06-04