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

Calculate target date from another date (excluding weekends and holidays)

Received Response
8
Views
41
Comments
edited Dec 11, 2017 10:30AM in Reporting & Analytics for B2C Service 41 comments

Content

Hi,

I have a requirement to show a 'target date' based on a custom date/time field. This is basically showing the target for a given team to deal with an incident and 'make a decision' about it.

When the incident is moved into a given status and a given queue, my Business Rules timestamp a custom field (let's call it 'assigned time'.

I then want to show - in a report - the 'target date' which is 5pm on the second working day. This should take account of working hours (0900-1700 Mon-Fri)

e.g.

  • assigned time = Monday 11am | target = Wednesday 5pm

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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