Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Calculate Age from a fixed end-date

Visitor ✭ ✭ ✭
# 1
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

Calculate Age from a fixed end-date

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I'm in the same trouble. It seems to be a problem with the fixed date '2016/12/31-00:00:00'. If instead of that you use a variable from you data set, it works. Does anybody know why?