Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Limit on date_diff — Cloud Customer Connect
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
25
Views
4
Comments
edited Nov 23, 2015 11:36AM in Reporting & Analytics for B2C Service 4 comments

Content

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

date_diff(sysdate(),contacts.Standard$wftdob)/(365.25*24*3600)

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.

Register

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