Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Age Calculation with a twist

TennMan
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

I need to calculate a player's age for a soccer league. The calculation needs to find the player's age (League_Age) on Aug-01-xxxx. For example, this season's age is based on the player's age on Aug-01-2001. This age will not be recalculated until Aug-01-2002.

For example, a player with a DOB of Aug-02-1990 will have a League_Age of 10 until Aug-01-2002, even though they have already celebrated their 11th birthday.

I've tried taking the age to number of days old then dividing by 365, but DOBs close to Aug-01 are occasionally wrong (due to leap years I presume). I need a method that is correct 100% of the time year after year, even when the DOBs are 31-July and 01-Aug.

Thanks

Case(Month(DOB) = 8 and Day(DOB) = 1,Year(Status( CurrentDate))- Year(DOB),

Month(DOB) > 7,Year(Status( CurrentDate)) - Year(DOB)-1,

Year(Status( CurrentDate) )- Year(DOB))

Create an account or sign in to comment

https://fmforums.com/topic/3423-age-calculation-with-a-twist/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.