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 ) )

1 Reply

  • 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 ) )