AnsweredAssumed Answered

Merged fields/variables time format incorrect

Question asked by LaRettaK on Aug 31, 2016
Latest reply on Sep 2, 2016 by LaRettaK

Product and version

FileMaker versions 11 - 15


OS and version

Confirmed in El Capitan 10.11.6



Time incorrectly adds decimal formatting when in same merge block as number formatted as decimal. 


How to replicate


1. Define a Number field and Time field, and populate them with some values, say 123.4 for the Number and 8:15:45 for the Time.

2. Merge the two fields in the same text block (for example: "An amount of <<Numberfield>> is due at <<Timefield>> today.").

3. Format the text block to display numbers as Currency or Decimal, Fixed number of decimals: [2], and to display times as [hhmmss].


The result looks like this: "An amount of $123.40 is due at 8:15:45.00 today." with two decimal zeros appended to the merged time.  Then change the decimal number to 5 decimals.  The time changes to 8:15:45.00000.


Workaround (if any)