I have a field for DOB. How do I calculate age? I had this in earlier verionsof Filemaker Pro but can't figure it out in Filemaker Pro 12.
You calculate age in v.12 the same way as in previous versions (from v.7 upward) =
Year ( Get(CurrentDate) ) - Year ( DOB ) - ( Get(CurrentDate) < Date ( Month ( DOB ) ; Day ( DOB ) ; Year ( Get(CurrentDate) ) ) )
Result is age in years. Make sure the calculation is unstored and the result type is Number.
There have been a lot of discussions on the form regarding age calculations. The following link takes you to "Generating Age from Date of Birth". Pardon the messy link
It may be that you had a custom function in your previous version that had been added but not transferred to the new version. Custom Function is discussed in the above link. There are a lot of other discussions (rabbit holes?) that you can meander down as well. I am sure there will be an answer in there that will meet your needs.
Welcome to the FileMaker Community Forum, holly
The above answers may help. Just for a "whoa!" moment, search for 'age' on this forum. You will get different methods and you'll learn that FileMaker has many ways to do the same thing. See what makes sense to you, & come back and ask questions if you need clarifications.
This KB (knowledge base) article has been around for a long time:
Retrieving data ...