Displaying time

[Ken Bliss]

Gary

thank you so much, yours worked perfect the first try.  I also want  
to thank Jim for his also, unfortunately I could not get Jim's to  
work for some reason.  The Midnight not displaying problem he  
mentioned is an issue but would never happen for my application so I  
went with Gary's.

Ken Bliss


On Jan 31, 2008, at 4:37 PM, Gary Yonaites wrote:


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

_______________________________________________
Qna mailing list
Qna at provue.com
http://provue.com/mailman/listinfo/qna