AnsweredAssumed Answered

SugarBPM Evaulating dates to set statuses

Question asked by lee Ingham on Aug 27, 2019

Im Trying to use SugarBPM to evaluate and set a status when a date field (in this case when a Date of last activity changes)

 

the scenarios are as follows

 

1. When last activity date changes > set status to "green" (this one is fine)

2. when the activity date is more than 10 days and less than 30 days > set status to "Amber"

3. When the activity date is more than 30 days > Set status to "Red"

 

ive tried using a business rule and found the conditon for the "activity date" >10d

also tried "activity date <10d isnt giving me what i need.

 

 

ive even tried Activity Date > Activity date +/- 10 days etc.

 

 

the workflow always evalutes just the first scenario and not the rest

 

I know we can easily do this with a scheduler job and code but really want to be able to use advanced workflow for a more front end configurable example.

 

any help would be greatly appreciated

Outcomes