>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 ...
I believe so.