Forum Discussion

kkhajanchi's avatar
kkhajanchi
Regular Visitor
3 years ago
Solved

CYYDDD conversion to calendar date

I am not able to convert the CYYDDD julian date to calendar date. Can anybody help?
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi kkhajanchi 

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi kkhajanchi 

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