I would try something like this:


replacde DOB with ;
date(val(substr(tmp, 1, 4)), val(substr(tmp, 5, 2)), val(substr(tmp, 7, 2))) ;
in clients


Hope it helps

Oscar

>Hi,
>
>This is simple, I know. But I can't figure it out.
>
>I am trying to replace a date field (date of birth) with a character value. The character value is as follows:
>
>19650824
>
>I have SET DATE TO YMD for this and I use the CTOD() function to do the conversion from character to date. However it is returning a blank date.
>
>Tmp="19650824"
>Replace Client.DOB with CTOD(TMP)
>
>What am I doing wrong???????
>
>
>Thanks.