>IM SORRY TO BOTHER YOU ALOT....IM SORRY
>THANK YOU.. I DID WHAT YOU DID, BUT ITS NOT WORKING..I THHINK THAT IS HAS TO DO WITH CTOD...
>
>MY CODE GOES LIKE THIS
>substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2)
>
>THIS CONVERTS 990501 TO 05/01/99..ITS A CHARACTER FIELD NOT A DATETIME FIELD
>
>WHAT COULD BE WRONG
That's what CTOD does...character to date. You can only use the CMONTH function on date type fields, that's why you have to use the CTOD function to convert the character string to a date type. What problem are you having?