- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 27, 2023 11:34 AM
I have a "Person" table that has birth date. On another table, I lookup that birthdate to find the person's current age when "Event" happened. Next year, a new "Event" will have different age for the person (as they are a year older). But I need to know what age they were at each "Event"
So how do I create a column of ages that are dynamic on entry, but don't change once they are entered?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 12:27 AM
Hmm, in the "Event" table, create a Date field called "Date of Event" or something, then create a formula field that will calculate the age by deducting the birthdate year from the "Date of Event" value year?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 12:27 AM
Hmm, in the "Event" table, create a Date field called "Date of Event" or something, then create a formula field that will calculate the age by deducting the birthdate year from the "Date of Event" value year?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 03, 2023 07:15 PM
Won't this formula update that result next year? OR are calculated fields only calculated once upon entry?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 04, 2023 03:45 AM
Hm, I was thinking the formula would caclulate the difference between the date of the event and the linked person's birthday, and so there'd be no updates regardless of the current date
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2023 12:09 PM
Got it. I misunderstood. Thanks!