Am trying to work out the current age from a date of birth - am using an equation field. Can someone help with the correct syntax please ... whatever I try does not work!
getDateYear(CurrentYear))-getDateYear({Date of Birth})
Thanks
thank you thank you
Simple and that worked!
Simple and that worked!
It has to do with the way dates are stored, zero being 01/01/1970 usually.
Change your operator from > to != (does not equals).
That was helpful I must have missed it.
I used this: {Date of Birth}>0?currentTime()-{Date of Birth}:0
Now funny thing is I got this to work in one record - but not the rest. See enclosed.
Any ideas?
I used this: {Date of Birth}>0?currentTime()-{Date of Birth}:0
Now funny thing is I got this to work in one record - but not the rest. See enclosed.
Any ideas?
Does either of these approaches work from the documentation? See http://helpdesk.knackhq.com/support/solutions/articles/5000642485-calculate-age-in-years-from-birthday