>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.
ctod() will give you warnings, because of possible ambiguities.
Better, if you use VFP 6 or later, use date(year, month, day) to create the date.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)