A READER ASKS
I download your example age calculation to use it in a database to calculate kids’ age in advance. I create a target global field with the target date but I can’t get the calculation to work,I will appreciate if you can please !!! help me to understand what I have done incorrect.
Not a problem, the example uses the Get(CurrentDate) function to evaluate the span between a birth date and the current date. What you will want to do is change every instance of the calculation where the Get(CurrentDate) is used and substitute it with the day in the future you want to evaluate.
That way you will be evaluating the span between the birth date and the determined future date. Use a global field if you want it to show for all the records in the file or use a regular field if the future date may change from record to record.
© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.