>This may be a little elementary for this forum but we have a couple of Foxpro2.6 and Foxbase applications and are concerned about Y2K. What would be the main areas to focus? I have been told to Set Century On and change date fields to the appropriate length. Is that all there is to it?
NO, you must take the following into account:
If you have a date field on a screen where the user types in the date; the user
might leave off the century. If your PC has the date set to 2000 or later, and the user does NOT type in the century, FPW will supply 19 as the century EVERY SINGLE TIME. This is the basis of the lawsuit filed against MS.
I solved it my gettting the field from the screen and comparing the century entered against the system date and when they did not match, I asked the user what century they wanted to use. This allows the user to enter dates from the past - say when it is Jan 2000 and the user is entering dates for 1999.