โ10-01-2019 07:25 AM
Hi everyone,
I have a date in Julian date format (2014003) and I need to convert it to YYYY-MM-DD (2014-01-03).
Is there a way I can do this in SnapLogic?
Thanks!
Solved! Go to Solution.
โ10-01-2019 07:47 AM
Ok, so I figured it out. I used:
Date.parse(โ2014003โ, โyyyydddโ).toLocaleDateString({format: โYYYY-MM-DDโ})
โ10-01-2019 07:47 AM
Ok, so I figured it out. I used:
Date.parse(โ2014003โ, โyyyydddโ).toLocaleDateString({format: โYYYY-MM-DDโ})
โ08-22-2022 07:18 AM
Hello,
I have a use case where the Julian date is attached to the file name e.g. sampleFile.216.txt. How would you suggest converting โ216โ into yyyy-mm-dd format?
Regards,
Marrah
โ08-22-2022 07:31 AM
@marenas - This topic already has a solution for the original question - please open a new thread for this
โ08-22-2022 07:42 AM
@koryknick, thanks for the response. I will open another thread.