* Original Area: 2000
* Original To  : Gerry Danen (1:167/722)
 Only 1103 days before year 2000, are you ready?
GB>  FoxPro, Maximus, Front Door, BlueWave, etc.
 GD> Why isn't FoxPro Y2K compliant?  You can store dates in 4 digits...
 YEAR 2000 BUG it's more than a 4 digits problems. Until now, lot of
 applications writing with Foxpro and others Database language was writing
 with only 2 digits for the year, cause it's more efficient to type only
 2 digits than typing 4 digits, a 50% effiency gain. And it's was good,
 it's work fine, everybody was happy. And A LOT OF APPLICATION do that,
 that way.
 When you receive an order or have a meeting for the next year or the
 next month, you enter the date and bingo, no problem. You stick with your
 2 digits date.
 Now, as we approche the YEAR 2000, we must change our programming
 because of our dear Foxpro, can't assume 2000, when you type 00, in your
 date field. We have to RE-WRITE ALL APPLICATION. Shame.
 How many application you use now and it's orphan, whitout the source
 avalaible. A lot.
 OK, you tell me, why FoxPro and other have to assume 2000, when
 you type 00. It's perfect to assume 1900. You kidding.
 Foxpro already assume and do a lot of test on the date field.
 Try to enter  29/02/2000 and after try to enter 29/02/1900.
 Which was good, please tell me. And try to enter 12/32/1996,
 your receive an error message, INVALID DATE. So it's assume a lot
 by itself.
 Must of the application for the database was for accountant or
 business purpose, and it's cover a short range of time, 5-10 years
 in the past and 5-10 years in the future. When you are in 1996 and you
 type 00 in a 2 digits numbers we can reasonbly assume it's for the
 year 2000, not for the year 1900.
 I hope next version will be corrected and we don't have to RE-WRITE
 all the nice application already done.
 Good luck in your YEAR 2000 VENTURE
 gilles@biwi.qc.ca      Moderator 2000
 PS: I do the same test yesterday with Access 7.0 for Window 95
 and it's NOT YEAR 2000 READY.
--- Maximus 3.01
---------------