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

    Replacing number with text

    Olex

      Title

      Replacing number with text

      Post

      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