>This is my code below:
>
>Tmp="19650824"
>a=Right(Tmp,4)
>b=Left(Tmp,2)
>DateString=(Left(Tmp,4)+"\"+b+"\"+Right(Tmp,2))
>
>Tmp2=CTOD(DateString)
>Replace Client.DOB with Tmp2
>
>It just isn't working for me. It is replace client.dob with {\\}!! Any suggestions?
In addition to what George has said, don't you really mean:
b=LEFT(a,2)
???
Otherwise you're creating a date string like "1965/19/24" which is invalid.