4 Replies Latest reply: Mar 31, 2017 9:25 AM by Audit Analytics RSS

    Convert Julian date

    Audit Analytics

      Hi all,

       

      I hope you can help with this quick query.

       

      In my data I have several date fields. The format of the dates is (from what I can see) "Julian" dates set as 7 digits:

      YYYY[day of the year in 3 characters]

       

      Samples:

      Date_of_Birth

      1965166
      1970259
      1965063

       

       

      Please can you help with a load script for this Date_of_Birth field, converting the above to "normal" dates in DD/MM/YYYY?

       

      Many thanks!