Get Current Date

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})


thank you thank you

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?

Does either of these approaches work from the documentation? See