1 Reply Latest reply on Jul 29, 2012 4:53 PM by s

    Time display for value list

    s

      FileMaker 12 on OS X

       

      I have a repeating field which contains a calculation to return a Time based on the number of the repetition. Every repetition represents 15 minutes, so the first repetition contains 0:00:00 (midnite), rep2 contains 0:15:00, up through rep96 contains 23:45:00

      The formula is (Get ( CalculationRepetitionNumber ) - 1 ) * 15 * 60

       

      In the table where this field is defined, I can put the field on the layout and set the format to display as hhmm with AM/PM and it looks fine:

      12:00 AM

      12:15 AM

      12:30 AM

      ...

      11:45 PM

       

      Next I create a value list from this field, assign it to a global field (of type Time) and format the global to display as hhmm with AM/PM and I get this:

      0:00:00

      0:15:00

      0:30:00

      ...

      23:45:00

       

      What am I missing? How do I make the value list display the AM/PM values?

       

      TIA

       

      --

      Steve Moore

      Cumberland, Maine