Passing format with report

[Futang44]

The problem is simple, I have a date pulled from my SQL database to Crystal Reports as a number formated YYYYMMDD. I would like to force format a number so any client who views it with any number format views it as I set it. (not YY,YYM,MDD.00 or any number of other formatting options they might set). This would not be an issue if I simply ran the report on my pc. Is there any formula I can embed to force-format a formula field?

[jggtz]

You can convert to text and parse it any way you want

Use functions : ToText, Mid, Left, etc.

[Futang44]

The field is edited before any conversion takes effect. Besides totext and the like has nothing to do with field formating, just information formating.