Calculate Age from a fixed end-date
Visitor ✭ ✭ ✭
I have issue on this formula
DATE_DIFF(TODATE('2016/12/31-00:00:00', 'BASIC', '%Y-%m-%d'), TODATE(birthday, 'DEFAULT_DASH', '%Y-%m-%d'))
Somehow it will give me an invalid formula, unless I changed the string date into actual field.
I'm trying to find fix for this