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

Calculating Time Left to Process using Relative Date Difference

edited Jun 16, 2016 12:53PM in Reporting & Analytics for B2C Service 4 comments

Content

We need a field that shows the remaining time to process on unresolved service requests. The formula created by our system integrator uses absolute time. It is written: if(incidents.status_type=2,0,response_reqs.rslv_within-( round(((date_diff(sysdate(),incidents.created)))/60,0)))

We need to capture the remaining time to process as relative time removing weekends and holidays. Because the rel_date_dif expression cannot be used in a nested formula, I'm having difficulty displaying the true remaining time on a service request before it becomes out of standard. I have tried:
rel_date_diff(incidents.rel_due,sysdate(),incidents.rr_id)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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