>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.