Hi John Try:
REPLACE rac.DDate WITH DATE(VAL(LEFT(aAr(2), 4)), VAL(SUBSTR(aAr(2), 5, 2), VAL(RIGHT(aAr(2), 2)))
>Thanks for the help Cetin. Can you help me with this.
>
>
>
>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.
Alexandre Palma
Senior Application Architect