BL Splash Posted April 23, 2002 Share Posted April 23, 2002 I have an age field that looks at another date of birth field to display the age. I was just looking at some of the records and a few have had a birthday have come and gone and the field doesn't update itself. Is there a way to do that? I thought I had seen a script for it, but can you run a script in a calc field? Any help would be very greatful. Blake Quote Link to comment Share on other sites More sharing options...
Praxis Posted April 23, 2002 Share Posted April 23, 2002 Function Today is recalculated when the host closes and reopens the file. If your db may not be closed and reopened once a day at least, you might opt for the Insert Calculated script step. Here's the calc field definition for age (or calculation to be inserted): NumToText(Year(Today) - Year(DateOfBirth) - Case(Today< Date(Month(DateOfBirth), Day(DateOfBirth), Year(Today)), 1)) Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.