Comment has posted this calculation before:
Let ( [
Today = Get (CurrentDate) ;
bDay = Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Today ) )
Year ( Today ) - Year ( Birthdate ) - ( Today < bDay )
Make sure your calculation is unstored in order for it to update automatically.
thank you guys!!!! IT WORKED!!!! :)
I just not sure what unstored is and how I make sureb that it is unstored???
When you enter the calculation for your field. You are using a dialog box titled "Specify calculation". There should be a button just above the Ok and Cancel buttons in the lower
leftRight corner labeled "storage options". Click that button and select the "do not store..." check box.
PhilModJunk I am not sure if it makes a difference, but I am using FileMaker Pro10 and when I am on the specify calculation dialog box the checkbox on the top left just above Ok and Cancel only says "Do not evaluate if all referenced fields are empty". Is that the same thing??!
I don't know my left hand from my right hand today :smileysad:
It's just above the OK and Cancel on the RIGHT hand side of the dialog box.