Displaying time

[Gary Yonaites]

On Jan 31, 2008, at 5:01 PM, Ken Bliss wrote:

> I want them to not show up at all if they are blank.  I
> thought the zeroblank would work, but could not find any way to get
> it to work.  Here is the actual display formula I am using on the
> FORM.  Any help would be greatly appreciated.
>
> {timepattern(«CALL ATTEMPT TIME»,"hh:mm am/pm")}

Try this formula:

{?(«CALL ATTEMPT TIME»=0,"",timepattern(«CALL ATTEMPT TIME»,"hh:mm am/ 
pm"))}

Gary
gary at yonaites.com