Jump to content

Birthdate/autocalculate cutoff?


This topic is 5707 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5707 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.