Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple problems
Message
From
01/04/1999 16:33:43
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00204417
Message ID:
00204457
Views:
25
Nadya...

While the date presentation is simple enough, I don't see how the expression builder could handle the 12-hour, AM/PM business. If you'd like, I can send you a copy of my UDF, but I don't think you'll be able to do it without some coding. I'd *love* to hear about an alternate solution... :)

Scott

>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.
Scott D. Grabo
Chief Information Officer
Occupational Health Group
First Advantage Corporation
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform