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