Article ID: 106690 - View products that this article applies to.
This article was previously published under Q106690
The FoxPro functions SYS(1) and SYS(11) return a Julian day number, which is different from a Julian date. To return a Julian date, you can write a user-defined function (UDF), as described below.
SYS(1) and SYS(11) return a date according to the Julian calendar, in which each day is counted, with day 1 being in 4713 B.C. On the other hand, a Julian date is a date represented by a five-digit number, the first two digits being the last two digits of the year, and the final three digits being the number of days that have elapsed since January 1 of that year. For example, 01/01/93 according to the Julian calendar is 2448989, whereas the Julian date is 93001.
The following program calls a UDF that converts a date in FoxPro date format to a Julian date.
Article ID: 106690 - Last Review: December 1, 2003 - Revision: 2.1