<< Click to Display Table of Contents >> Navigation: Apollo API Listing > sx_GetDateJulian |
Declare Function sx_GetDateJulian Lib "Apollo9.dll"
(ByVal cpFieldName As String)
As Long
LONG FAR PASCAL sx_GetDateJulian
(BYTEP cpFieldName);
Extracts the contents of a date field as a Julian number. This number is equal to the number of days since January 1, 4713 BC. However, only JULIAN dates equal or greater than January 1, 1000 are supported.
cpFieldName: The name of the field.
The date expressed as a long integer. Useful for date arithmetic.
' calculate days it takes customer to pay
lDays% = sx_GetDateJulian("PAYDAY") - sx_GetDateJulian("SALEDAY")
LONG lDays;
lDays = sx_GetDateJulian("payday") - sx_GetDateJulian("saleday");