Help

Re: Formula Tips for Other Users

691 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tech_Tylercivic
7 - App Architect
7 - App Architect

For 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.

3 Replies 3
Tech_Tylercivic
7 - App Architect
7 - App Architect

Me, 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?

Kasra_Kyanzade1
6 - Interface Innovator
6 - Interface Innovator

I 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!

Tech_Tylercivic
7 - App Architect
7 - App Architect

Kasra, Well, of course. I wonder why I missed this obvious (now) solution.