Troubleshooting
Problem
How can a 7 digit Julian date be converted to a standard date?
Resolving The Problem
This is the calculation used to convert a standard Julian date which is in
7
digit numeric format to a standard date.
Example
1998321 to 11/17/98
F1 = Julian date in following format
YYYYDDD
datetime-to-date ( days-from-1900-to-datetime
(
date-to-days-from-1900 (datetime-to-date
( make-datetime (
string-to-integer ( substring ( number-to-string ( F1 ) ,
1 , 4 ) ) , 01
, 01 ) ) ) +
string-to-integer ( substring ( number-to-string
(
F1 ) , 5 , 3 ) ) - 1 ) )
For 5 digit Julian date
conversion see support document:
65485 - Convert Julian date to a normal
date within Impromptu
Historical Number
66983
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21348498