Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
New here, and looking for some advice on how to calculate the age of a member, and then only display the member in the table if their age is greater than 26.
I am already using the following expression to calculate age, but I'm not able to determine how to only display if greater than 26.
=Age(Now(),MEMBER_BIRTH_DATE)
Any help would be appreciated, thanks!
Hello,
A simple if should do the trick:
=if(Age(Now(),MEMBER_BIRTH_DATE)>26, Age(Now(),MEMBER_BIRTH_DATE), null())
Hope it helps.
Hello,
A simple if should do the trick:
=if(Age(Now(),MEMBER_BIRTH_DATE)>26, Age(Now(),MEMBER_BIRTH_DATE), null())
Hope it helps.
That did the trick, thank you so much!