Escalation on Dynamic Date

Hi Ryan, 

The "Escalate On" option for escalation rules allows you to specify a dynamic date and have it then repeated every day for a certain duration.  The only issue is that at this time you will have to call some external reference to do the date calculation.  For instance a web service that takes the start date of the activity and the expected duration of the task and returns (StartDate + (ExpectedDuration - 10).  You could then use the return date in the escalation rule.

There is a new feature in the works for K2 blackpoint and K2 blackpearl called inline functions which when released will allow for many of these types of calculations within the K2 tooling directly.

-Eric

Hi Ryan,

I did a quick test and it appears that SharePoint is returning something like this for a calculated date field:

Datetime;#2009-04-14 00:00:00

That is probably the issue as K2 is likely expecting a straight date.  I will follow up with our team on this.

-Eric

Hi

Eric is correct - this is the best way to achieve this. SharePoint date field will return some extra characters as you have noticed.

There are inline functions which let you "subtract days" from a date by specifying the date field (process data/SMO output etc) and the number of days as integer to subtract.