Solved: CYYDDD conversion to calendar date

kkhajanchi · ‎03-22-2023

I am not able to convert the CYYDDD julian date to calendar date.

Can anybody help?

tamerj1 · ‎03-22-2023

assuming dates are in the 2000 +
Date =
DATE ( 2000 + VALUE ( LEFT ( 'Table'[JD], 2 ) ), 1, 1 )
+ VALUE ( RIGHT ( 'Table'[JD], 3 ) )

tamerj1 · ‎03-22-2023

assuming dates are in the 2000 +
Date =
DATE ( 2000 + VALUE ( LEFT ( 'Table'[JD], 2 ) ), 1, 1 )
+ VALUE ( RIGHT ( 'Table'[JD], 3 ) )

CYYDDD conversion to calendar date