DateToJulian

Returns a numerical value corresponding to the Julian Date equivalent of the specified date.

The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month.

Julian Date indicates the number of days that have elapsed since January 1st, 1900.

Usage

DateToJulian(YYYMMdd)

Where: YYYMMdd - a numerical expression, specifying the date in YYYMMdd format

Example

DateToJulian (1080101) will return a value of 39448, corresponding to the specified date 
of January 1st, 2008

DateToJulian (990402)  will return a value of 36252, corresponding to the specified date 
of April 2nd, 1999