2 Replies Latest reply on Mar 7, 2016 6:58 PM by Shinichiro Murakami

    Need help converting Julian Date Format

    chaelin.kwon

      I'm trying to convert some dates that are currently in the "modern julian date" format (7 digits before the decimal point) to mm/dd/yyyy hh:mm:(ss)

      I tried using the information from this page: Converting JDE Julian Date Fields to a Supported Date Format | Tableau Software

      but the calculations on that page are for 5 or 6 digit numbers. Has anyone done this before? What should I do?

       

      Thanks in advance!