3 Replies Latest reply on Feb 11, 2010 4:01 AM by comment_1

    Replacing number with text



      Replacing number with text


      Hello everyone.

      I have a small question. I'm using FileMaker 10 (Mac).


      I have a field "Birthday Year", that is a number field.

      Then I calculate the age of the person by "Year(Get(CurrentDate)) - Birthday Year", so i get the desired age in the "Age" field (Calculation field).

      Now i want the "Age" field display "Adult" if the person is over 20 years old instead of the actual age.

      Is it possible?


      Any help would be appreciated.


      Thank you