Displaying time

Ken Bliss kbliss at blissindustries.com
Thu Jan 31 16:01:40 PST 2008


This seems simple, but I cannot figure out a way to make it work.  I  
have a field  CALL ATTEMPT TIME  that we put in the time of day from  
a form using a simple button that triggers a procedure that posts    
now() in that field.   it shows in seconds since midnight per the  
manual and works perfectly.  Now we have a different FORM that  
displays this time.  However many of the records have no time in  
them, and are blank.  All of the blanks are showing up in the FORM as  
12:00 AM, 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")}

Ken Bliss


More information about the Qna mailing list