Date Field Precision for Paradox, Visual dBASE and InterBase are as follows:

Paradox Date Field Range is from January , 9999 BC to December 3 , 9999 AD. Paradox correctly handles leap years and leap centuries and checks all dates for validity. Paradox treats all BC years as leap years.

dBase In dBASE III+ to Visual dBASE for Windows 5.5 Date Field Range is from January , 0000 to December 3 , 9999. For all versions of dBASE from version III+ to the current Visual dBASE for Windows 5.5, date fields are stored as a string in the format YYYYMMDD. In dBASE III+ a new SET CENTURY command was added for the approaching 2 st century. SET CENTURY ON allows display and editing of the 4 digit year. SET CENTURY OFF limits display and entry of the year to 2 digits. All calculations and storage involving date fields handle the year correctly regardless of the state of SET CENTURY. With SET CENTURY OFF, the command, STORE {0 /0 /2000} TO MYDATE, will display the year as 00 even though it is stored correctly on disk and in memory as the string 20000 0 . Note that the YEAR function always returns a 4 digit year.

InterBase Date Field Range is from January , 00 to December , 594 . InterBase supports a DATE data type that stores dates as two 32-bit longwords. An InterBase DATE data type includes information about year, month, day of the month, and time.

2/ 6/ 998 2: 4:28 PM