>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???????
>
>
Hi Jolene,
You really can't do this, since VFP can't see any delimiters and evalutes it as an invalid date. Just FYI, however, the format you're using is exactly the same way VFP stores dates internally.
George
Ubi caritas et amor, deus ibi est