user15252 Member

This is the formula for julian yyyyddd —- date(dateadd(day,"Julian_date"% 1000,dateadd(year,(a."Julian_date"/1000),convert(datetime,'01/01/1900')))-1) It works in ETL2. I would assume there is something similar with the Century format

I want to do it in magic ETL2 - to work with it in my etl

I assume I replace 'julian' with the julian date field name. I tried that and it did not work - Here is the error - which makes sense :

What would the formula be for Julian dates with century - Cyyddd?

Good idea