I have a report that required a ToText statement on the datetime field. I only want the Date displayed (mm/dd/yyyy) and no time stamp. I get it to run on my machine fine, but when I post this to Crystal Enterprise the time stamp shows up?? It seems as if the ToText statement is being ignored...any ideas?

Did you try to Format the field in Crystal?

Try this...

ToText(Date({FIELDNAME}))