Skip to main content

I want to configure an event escalation to send an e-mail 10 days before the due date and then each day thereafter until complete. How do I do this?

Thank you.

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


Eric,
Thanks for your reply. One thing I tried was to make another field in the sharepoint list called "Notify Date". I made this a calculated field that was "[Effective Date]-10". However, Blackpoint was reading that as "1/1/0001 12:00:00 AM". Can Blackpoint not read calculated date fields properly?

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.


Reply