Hi Scott:
Thanks for your reply.
>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 thought, that there is an easier way to do it, using datetime() function. I see, that I was wrong. Are you sure that we can not use Format in Report Builder Expression for this goal?
>
>>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.
If it's not broken, fix it until it is.
My Blog