I believe that the programmer was saving the date as a two digit year. So, I guess what I'll have to do is look where they saved the date as a two digit value and change it to four digit value. It sounds like this should solve the problem. Does that sound right?
Jason
>>Hi Rob. I am the originator of this thread and I have narrowed the problem down to what you've identified: CTOD(). It looks as if everytime this is used it returns '1900' as the year. Any suggestions as to how to fix this. Your help would be extremely appreciated.
>>
>>TIA,
>>
>>Jason
>
>DTOC( ) returns an 8-character string if SET CENTURY is off, and it returns a 10-character string if SET CENTURY is ON. CTOD( ) defaults to the 20th century (19xx) if the string includes only a 2-digit year (mm/dd/yy), but works fine for Y2K if the string has a 4-digit year (mm/dd/yyyy). What problems are you running into?
>
>(snip...)
>
>>>The only problems I have found are regarding DTOC() (we have some old legacy stuff taken over from other developers that uses DTOC() in index tags !!!)
>
>SET CENTURY ON and reindex.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement