Return to FileMaker.com
In my data base I used a auto-calculation to determin age:
Year ( Get ( CurrentDate ) ) - Year ( Birthday ) - If ( Get ( CurrentDate ) < Date ( Month ( Birthday ) ; Day ( Birthday ) ; Year ( Get ( CurrentDate ) ) ); 1 ; 0 )
Which works great except it won't update the birthdates when their birthday passes. How do I get it to do that?
Under Storage Option fot the calculated age field select Do not store calculation - recalculate as needed.
Retrieving data ...