Julian Date to YYYY-MM-DD

[philliperamos]

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!

[philliperamos · Accepted solution]

Ok, so I figured it out. I used:

Date.parse(“2014003”, “yyyyddd”).toLocaleDateString({format: “YYYY-MM-DD”})

[marenas]

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

[koryknick]

@marenas - This topic already has a solution for the original question - please open a new thread for this

[marenas]

@koryknick, thanks for the response. I will open another thread.