• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Intuit Products   QuickBase  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
10298
aCvNP4u6Or4yUOacwZ5xHE
Subscribe RSS
cwade723
cwade723
Questions asked: 3
Questions answered: 1
Points earned: 1
cwade723
cwade723
Questions asked: 3
Questions answered: 1
Points earned: 1
Employee
02/09/12 9:43pm PST
Viewed by asker 02/15/12 8:45am PST

Formula to calculate league age

US QuickBooks Online Edition

I am looking for a formula that will calculate what a persons age will be on a specific date based on his DOB. We have athletes who's league age is determined on what their age is on 7/31. Example, a player who is born on 12/29/2002 is league age 9.

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
8 Replies
Mark_Shnier
Mark_Shnier
Questions asked: 84
Questions answered: 2943
Points earned: 6706
Allstar
Allstar
Advisory council of community power users.
Mark_Shnier
Mark_Shnier
Questions asked: 84
Questions answered: 2943
Points earned: 6706
Allstar
02/10/12 6:30am PST

Try this.

var date AgeTestDate = Date(Year(Today()),7,31);
var date BirthdayThisYear = Date(Year(Today()),Month([DOB]),Day([DOB]));

Year($AgeTestDate)-Year([DOB])
-
If($BirthdayThisYear>=$AgeTestDate,1,0)

 

Note that the ages will jump by one year on January 1st of each year automatically.

 

Mark Shnier

Mark Shnier

http://community.intuit.com/me...

http://ca.linkedin.com/in/mark...

If this post answers your question, please mark it as "Solved".
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
 Report Abuse
 
 
 
dandiebolt
dandiebolt
Questions asked: 59
Questions answered: 1760
Points earned: 3676
Allstar
02/12/12 8:59pm PST

You can't use a formula that includes the Today() function because the intent of the formula is to capture the participant's age for a particular year, school session or season. Using Today() will cause the formula to change values as time progresses. Instead you need to introduce another input reflecting a particular year, school session or season and derive the which year the 7/31 cutoff date refers to.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
cwade723
cwade723
Questions asked: 3
Questions answered: 1
Points earned: 1
Employee
02/12/12 9:52pm PST

Bare with me as I am not a programmer but I am not sure that I totally follow. If I the age cutoff is 7/31 of this year to determine league age and I have a player who's birthday is 12/29/2002 then his league age would be 9. Whatever a players age is as of 7/31 is what we go off of.

Based on this, would the above formula offered by Mark still not be valid and if not, what should change?

Thanks again

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
dandiebolt
dandiebolt
Questions asked: 59
Questions answered: 1760
Points earned: 3676
Allstar
02/12/12 10:16pm PST

When we discuss a cutoff date for a sports season we are implicitly assuming everyone is talking about the current, upcoming or a specific season.  Mark's formula needs to be modified to determine the cutoff year from some other field in your table that identifies the season the player in participating or qualifing for. Perhaps you have a field in your table with values such as "2011/2012", "Spring 2012" or simply "2012". This field should be used to determine the year which feeds Mark's formula. If you use Today() as a proxy for  identifying a specific season the formula will only be accurate during that specific season - it will not be accurate in the future.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Mark_Shnier
Mark_Shnier
Questions asked: 84
Questions answered: 2943
Points earned: 6706
Allstar
02/13/12 4:40am PST

Yes, my formula assumes the simple case, that its a calendar year roll over  - which in fact for a little league type operation is probably good enough.  It also has some intuativeness for low tech users as it answers the question as to the kids' ages for the current season.  "How old will the kid be in the summer".  ie the summer of the year you are in.

Yes, if the league planning for the 2013 season starts in the fall of the 2012 year, there could another enhancement to the formula for a cut off as to when the year rolls over (as opposed to a calendar year roll over).  But in reality, users will know that next year the the kids will all be a year older so if the kid is only showing 8 years old at Chrstmas, then they are good to play next year because on January 1st, all the ages will advance by 1 year.

Mark Shnier

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
dandiebolt
dandiebolt
Questions asked: 59
Questions answered: 1760
Points earned: 3676
Allstar
02/13/12 5:37am PST

It will never work with such simplicity. Kids today are on multiple teams with overlapping seasons (indoor, outdoor, travel, recreation, competitive, camps) and some leagues have criteria other than age to join a team. Also you will have to track the parent's activities to make sure they bring the snackie cakes, juice drinks, refreshments, awards and favors for the afterglow parties. It is best to level up for the complexity and generality this application will ultimately demand.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Mark_Shnier
Mark_Shnier
Questions asked: 84
Questions answered: 2943
Points earned: 6706
Allstar
02/13/12 6:44am PST

Dan, you seem to be very experieced in Big League development work for Little League, so you have probably done work on this area before. .

All kidding aside, I'm sure a full featured app  for managing the full scope of team activities would be a very complex app!

Mark

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
ddixonr
ddixonr
Questions asked: 25
Questions answered: 54
Points earned: 91
Contributor
02/13/12 9:12am PST
Latest post

You guys are funny. Here's is my age formula for my application. Because I deal in the healthcare industry, and people die, I don't want the age field to continue making them older.

Year([DOD])-Year([DOB])-1
+
If(Month([DOD])>Month([DOB]),1,0)
+
If(Month([DOD])=Month([DOB]) and Day([DOD])>=Day([DOB]),1,0)

 

I'm sure the OP could just replace DOD with a field set to 7/31

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • us quickbooks online ed...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Memere
44 secs ago
Memere
replied to
updateding to 2012 changed ...
Memere
1 min ago
Memere
replied to
Copy Cleared Check
Starlett
2 mins ago
Starlett
replied to
Job Costing Non-Inventory S...
Mistyblue
2 mins ago
Mistyblue
replied to
Why does my QBs, in multi-u...
Jen121
2 mins ago
Jen121
replied to
updateding to 2012 changed ...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business