Article ID: 106690 - View products that this article applies to.
This article was previously published under Q106690
This article has been archived. It is offered "as is" and will no longer be updated.
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: February 28, 2014 - Revision: 2.1