5 Replies Latest reply on Aug 9, 2018 5:12 AM by John John

    Order Date to Julian Date

    John John

      Hello,

       

      I would like to convert my order dates in both Julian (CYYDDD) and modern Julian date format (YYYYDDD).

       

      So let's say 07/13/2018 should be converted to 118194 and 2018194.

       

      I can keep the str of the order date like below but then my issue is how to get to 194 number

       

      str(YEAR([Order Date]))

      str(Month([Order Date]))

      str(day([Order Date]))

       

      This resource shows how to conver Julian to date but not the other way around.

      dates | Drawing with Numbers

       

      Thanks!