Birthdate/autocalculate cutoff?

[t-mac]

Thank you in advance! I need help and I need it today if possible because this has to be ready by tomorrow. I have set up database in version 5.5/mac registering children we are signing up for ball season. I do not how to set this part and I need step by step.

We need to be able to enter the childs birthday example 12/02/1998 and then it needs to calculate their age up to Aug. 1. I will need to have it specify the age up to that time. August 1st is the critical because their age to that time is the group/team they play with.

Help please. Thanks again.

[-Queue-]

Try using an unstored calculation with a numeric result of

Year(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)) )) )) - Year(birthdate) -

(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)))) ) < Date(Month(birthdate), Day(birthdate), Year(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)) ))) )))

This should give you the age up to August 1st of the current year. If today is after August 1st, then it gives you the age as of next August 1st.

[t-mac]

Bear with me...very easy for me to do layout and simple fields but I am calculation ignorant

What fields do I use and where would this go?

Do use a date field for the entry and then set this calculation with the age field?

Please be step specific

Thanks

[-Queue-]

No problem. See if the attached helps.

Ages.zip

[-Queue-]

And please, refrain from multiple-posting. I have already deleted two almost-identical posts in other forums.

[t-mac]

Sorry, didn't realize that we are not allowed to post in other areas.

[t-mac]

That's great!

I'm so glad there are nice folks that can do formulas. We all have different talents.

Have a great weekend!