I guess I missed that detail,so yea just using CTOD(), and then DTOS(),.. he does want the final result to be a character string right?

>>Doesn't DTOS()do that?
>>
>>>I assume that all years are to be in the 1900's.
>>>
>>>

SCAN
>>>   lnAt = At("/", MyDate)
>>>   lcMonth = Left(MyDate, lnAt - 1)
>>>   lnAt2 = At("/", MyDate, 2)
>>>   lcDay = SubStr(MyDate, lnAt + 1, lnAt2 - lnAt - 1)
>>>   lcYear = Str(1900 + Val(Right(MyDate, Len(MyDate) - lnAt2)), 4)
>>>   REPLACE MyDate WITH lcYear + "/" + lcMonth + "/" + lcDay
>>>ENDSCAN

HTH

---

>I have a character field with a date stored in it in the following format
>>>>
>>>>mm/dd/yy
>>>>
>>>>I need to get this to be in this format ccyymmdd
>
>Yes, but that assumes you have a date field not a character field. Perhaps if you convert to date prior to doing any conversion ...