AnsweredAssumed Answered

Time display for value list

Question asked by s on Jul 29, 2012
Latest reply on Jul 29, 2012 by 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:







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





Steve Moore

Cumberland, Maine