Julian to Date/Time

Converts a Julian date string to a date.

The string must be a Julian date string, for example 02105. The Julian date string must consist of only digits, and may have a length of 3, 4, 5, or 7 digits. In each case, the last 3 digits specify the day of the year, with 001=January 1, 002=January 2, 031=January 31, 032=February 1, etc.

If the Julian date string has 7 digits, then the first 4 digits unambiguously specify the year. If the Julian date string has 5 digits, the first 2 digits are taken as a 2-digit year that is then resolved to a complete year value using the normal pivot year mechanism. If the Julian date string has only 4 digits, then the first digit is taken as the least significant digit of a year. In order to resolve this to a complete year value, JulianToDate assumes that it refers to some year within the last 10 years.

The function returns n/a if the given string cannot be interpreted as a Julian date.

Convert Julian to Date/Time

  1. Right-click on a Text field and select Time > Julian to DateTime in a context menu.

A new column with the converted values is added in the Data Preview.