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