AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.9K members online now
1.9K 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?