Convert Julian date yyjjj to yyyyMMdd in Azure data factory

Question

I have incoming date yyjjj need to convert to yyyy-MM-dd in Azure data factory

for 10010 is 2010 January 10th , this need to converted to 2010-01-10 . Please help

Answer 1

Try using below like expression. Couldn't figure out any other way rather than hardcoding

I am first creating a date 2010-01-01 and then adding (10-1) days to it

@formatDateTime(addDays(concat('20',substring(variables('JD'),0,2),'-01-','01'),add(int(substring(variables('JD'),2,3)),-1)),'yyyy-MM-dd')

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav