Displaying time

[James Rea]

> > 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"))}

The only problem with that is if a time is midnight, it won't show.
Here's a way to fix that.

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

I put {...} around the formula because you (Ken) did originally -- I
assume you are using an auto-wrap text object. Of course this will work,
but for new applications I pretty much always use Text Display
Superobjects since they have many more options (especially for text
smoothing, which looks nice on OS X).

Jim Rea
President, ProVUE Development

---------------------------------------------------------------------
---   Celebrating 29 years of software excellence (1978-2007)     ---
---------------------------------------------------------------------
ProVUE Development          (714) 841-7779
18685-A Main Street PMB356  http://www.provue.com/
Huntington Beach, CA 92648  Panorama: Turn information into knowledge
---------------------------------------------------------------------