You have to add @R so none-formating characters are inserted instead of overlaying.
@R 99/99/9999
>
>Thanks, that worked. Now what about for dates that are characters. my date comes in as 05232007 where it is MMDDYYYY. I went into the report expression and applied following format
>
>@D MMDDYYYY
>
>but the date comes out as 05/02/00. I also tried ctod(PROCESSDATE)in the expression but that didn't work either.
>
>thanks
>Nick
--sb--