Nadya...
Craig is right: you can get the 12 hour format with a simple SET command, and you can get rid of the seconds with SET SECONDS. I had written the UDF a)before we had the DATETIME() function :) and b)to get rid of the leading "0" in the time.
>Hi Scott:
>
>> While the date presentation is simple enough, I don't see how the expression builder could handle the 12-hour, AM/PM business.
>
> If I use datetime() function for current date and time info, it works fine without coding (see Crajg letter).
>
>If you'd like, I can send you a copy of my UDF, but I don't think you'll be
>
> Yes, it will be very helpful for me, thanks. I store time in character 10 field.
>
>able to do it without some coding. I'd *love* to hear about an alternate solution... :)
>
> I think it depends on what do you want to display.
Scott D. Grabo
Chief Information Officer
Occupational Health Group
First Advantage Corporation