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