>>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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only