>>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?
>
>That's basically it. Remember all the places you may have date fields -- screens, reports, UDFs, code, etc.
Actually, you also need to be aware of calculations involving CTOD() because you can loose century information:
ldBegin = CTOD("12/01/" + SUBSTR(STR(YEAR(DATE()) - 1, 4), 3, 2))
ldReturn = CTOD(STR(MONTH(tdDate), 2) + "/" + ;
STR(DAY(tdDate), 2) + "/" + ;
'20' + RIGHT( STR(YEAR(tdDate), 4), 2) )
In both examples, then century info is being lost. If you use these variables to store data or in further calculations, you might not get the results you expect.
- Harry
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only