You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Limit on date_diff

Accepted answer
edited Nov 23, 2015 11:36AM in Reporting & Analytics for B2C Service 4 comments


I'm trying to use the date_diff function in a segment to find contacts over a certain age, and am having some trouble, so I tried putting the same code in a report and it seemed to cap everything at 45.89 years, or 1,448,278,471 seconds, so anyone over this age just returned 45.89 years


is there any way to remove this cap? Or any way to identify a date difference this large, I want to exclude everyone who is 75 or over! 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!