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 ...