>I have some records in my system from our mainframe that have the year as 1900. Does anyone know of a simple way I can:
>
>1. Change the year to 2000
>2. Code in my pre-processing routine to prevent this from happening..
repl date_field with ctod(left(dtoc(date_field),6)+"2000")
Imagination is more important than knowledge
