Use the $JUL2GREG() function to convert a Julian-format date to Gregorian format.
The $JUL2GREG() function has this syntax:
gregdate = $JUL2GREG(juldate)
The $JUL2GREG() function takes these arguments:
Gregorian-format date: mm/dd/yy or mm/dd/yyyy. The number of digits assigned to the year will be the same as specified in the Julian date. The month and day fields will be two digits each, and will be left-padded with a zero, if needed.
Julian-format date: yy.ddd or yyyy.ddd. The number of digits assigned to the year will be carried over to the result and must be either two or four. The number of digits occupied by the day is unimportant except that it must represent a valid date.
The $JUL2GREG() function produces these return codes.
ARG 1 MISSING OR INVALID
INVALID YEAR
INVALID DAY
Example
$JUL2GREG('96.366') == '12/31/96'
$GREG2JUL('2000.001') == '01/01/2000'
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |