Is it possible to write some sort of date formula that will take a Date of Birth and not just calculate their age, but their age as of a set date? In my particular example, I'd like to be able to calculate someone's age based on their date of birth as of 10/1/2020. I'm racking my brain to try and come up with something in a hurry and was hoping someone might have thoughts as to how to make this work. Thanks!
Question
Question
Answer
SELECTED ANSWER
replied on August 17, 2020
Check out this Answers post from this morning:
https://answers.laserfiche.com/questions/177368/Age-calculation-error-in-table#177369
Susan uses a DatedIF formula
DATEDIF(Birthday,SomeDate,"y")
Hers may be a little more complex in that she's doing this per each row in a table, but the concept is the same, just give it a birthday and your future date.
1
0
Replies
You are not allowed to follow up in this post.