FIeld Calculation to show me Commencing Date

[Nestor]

Hi All,

I need help with a calculation, and to be honest i don't know if its possible.

I have a Birthdate Field, and Member Date Field for over 2000 members.

I just created a new field call "commensing field"

what i want this field to provide me is a year of when any member will be an Honorary membership.

If order to be an honorary memeber, a member has to be older than 75 years of age, as well as 25 or more years as a member.

So with that said, this new field has no provide me a year that will tell me the year that member will be honorary.

Any ideas how i would start this calculation. My first idea was an if statement, but creating one is turning out to be harder than i thought..

THanks

[comment]

Wouldn't that be Max ( Birthdate + 75 years ; Member Date + 25 years )?

[Nestor]

YES..

Thanks.