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

    Order Date to Julian Date

    John John



      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