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

Exception on date plus 1 additional filter

edited Oct 4, 2016 8:57PM in Reporting & Analytics for B2C Service 2 comments

Content

I'm having difficulty with the logic here.  I'm trying to create an exception on a date column where the date equals the system date, and the status has a specific value.  I was able to create an exception with similar parameters, showing past dates:

If(opportunities.statis_id = 118, date_diff(sysdate(), opportunities.c$call_by_date)/3600)  is greater than 24.

Is there a way to alter this to hit when the date equals the system date?  Or is there a better approach?  Thanks.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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