I've written a simple UDF that formats time as 12-hour AM/PM. You could make your report expression: "DTOC(DateTimeField) + TimeFunction(TIME(DateTimeField))", where TimeFunction is the UDF.
>I want to display datetime() in report in this format: 4/1/1999 3:21 PM, how can I do that? And other little problem: I change a backcolor of one field in detail (in order to underline it), in design mode I see this, but in the Preview or Print I don't see anything.
>
> Could somebody help me?
>
> Thank in advance.
Scott D. Grabo
Chief Information Officer
Occupational Health Group
First Advantage Corporation