Function: DateToJulian
Description
Converts a date to a Julian date string of the given length. Default length is 5.
Syntax
DateToJulian(date[,length])
Arguments
Date can be any date value. Length is an optional length to specify how many digits of Julian date are desired. The default length is 5. Valid lengths are 3, 4, 5 or 7. If no length is specified, then the default length of 5 is used.
Return value
The return value is a Julian date string of the specified length.
Calculated field example
The following expression will return 2003305 from a Date field containing 11/1/2003 12:05:33 AM: DateToJulian(Date)
Filter/Find example
Records in the Date field with a value equivalent to the Julian Date string of 2001121 can be selected or found using the expression: DateToJulian(Date,7)=2001121
© 2024 Altair Engineering Inc. All Rights Reserved.