+4For us newbies, is there a place where users are posting tips and techniques?
For example, I finally came up with a formula to determine someone’s age if you have their date of birth.
DATETIME_DIFF({D.O.B.}, TODAY(), “days”) / (-365)
Anyway, just thinking that there are a lot of experiences users who might want to share their own tips.
+4Me, again. Actually, that formula doesn’t exactly work because of leap years. You’d think dividing by 365.24 (the exact length of a year in days) would do the trick, but rounding doesn’t work when the birthday is just a day or two before/after the current date. So, who has the formula to determine a person’s age, knowing their date-of-birth?
+9I think this will do what you want:
DATETIME_DIFF(TODAY(), {D.O.B.}, “years”)
Good idea about a place for tips & techniques, I’ll pass it along!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.