Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 294 subscribers
  • Views 1396 views
  • Users 0 members are here
Related content from around SugarClub

Date Calculation in Process Definition or Business Rule

Steve Jaspar

I'm trying to compare two date fields in a single record, then perform a process if the difference between those dates is greater than 30 days.

So the criteria for the action is IF Date1-Date2 > 30 days

I see how to compare a date to a specific date, but not how to compare to another date field.

Parents Reply Children
  • 0 in reply to André Lopes

    A formular can look like this:

    subtract(daysUntil($enddate_c),daysUntil($startdate_c))

    The issue you will face is that this field only calculates when the record changes so if nothing happens to the target record the advanced process will not trigger and you will miss most of the events.

    You need to find a way to update your target records repeadingly with something like a scheduler.

    Edit: No issue with updating the calculation. You only need to recalculate the values for existing records once you have created a field with such a formula.

    Bests

    Björn