>Thanks for the help Cetin. Can you help me with this.
>
> REPLACE rac.DDate WITH SUBSTR(aAr(2),5,2) + '/' + SUBSTR(aAr(2),7,2) + '/' + SUBSTR(aAr(2),3,2)
>
>DDate is a date field. aAr(2) holds the value "20011113". when I issue this
>command I get a type mismatch. After I send you this am going to research if
>foxpro has some kind of type conversion function. Thanks again.
REPLACE rac.DDate WITH ;
ctod(SUBSTR(aAr(2),5,2) + '/' + SUBSTR(aAr(2),7,2) + '/' + SUBSTR(aAr(2),3,2))
However above is not only cumbersome but 'set date' dependant (under different settings would produce unexpected results). Safer :
REPLACE rac.DDate WITH ctod( transform(aArr(2), '@R ^9999/99/99') )
For date conversions check Ctod(), dtoc(), date(), ctot(), cmonth() ...
For time conversions check ttod(), ttoc(), ctot() ...
Cetin