Help with age calculation

[habitude]

I'm trying to calculate players ages determined by a set date.

For example, I need to find out how old a player will be by April 30, 2008 when the players birthdate is entered.

Can someone please help me with this? Thanks

Using 8.5 Adv on WinXP

[Orlando]

Hi habitude

Here is a calulcation I use foer one of my applications that does the same thing.

This uses two fields a Date Of Birth and a Cuttoff Date, and it will work out the persons age on the Age Cuttoff Date.

Let ( [



dob = Date of Birth ;



CutoffDate = Age Cutoff Date 



] ; // Start of calculation



If ( not IsEmpty ( dob ) ; 



Year ( CutoffDate ) - 

Year ( dob ) - Case ( CutoffDate <

Date ( Month ( dob ) ; Day ( dob ) ; Year ( CutoffDate ) ) ; 1 ; 0 )



; "" ) // End of If function



) // End of Let function

I hope this helps

Regards

Orlando