>>this is my actual line of code
>>
>>my field is a character field and it comes from a harris PBX like this
>>990501
>>so if i apply this line of code to 990501 like such
>>
>>substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2)
>>
>>i get 05-01-99
>>i need to get May-01-99
>
>Right. So if you do this:
>
>dVar = CTOD(substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2))
>YourNewString = CMONTH(dVar)+'-'+substr(view1.strtdate,5,2)+'-'+substr(view1.strtdate,1,2)
>
>You should get:
>
>May-01-99 in the variable YourNewString.



thank you much.....it did not work but i do not want to keep bothering you..
im trying to place it on a report, thats what i did not tell you...