Populate number of days between an opportunity's close date and date service begins

Hi Armena, I think you can do something like this to calculate the number of days between two datetimes in a SugarLogic formula:

abs(subtract(daysUntil($date1),daysUntil($date2)))

Would this work for you?

-Brenda

Hi Armena,

Could you please specify whether the task is to calculate the difference between two dates or track the number of dates from a particular date of some event (contact signed) and up to now?

Sugar logic works well to calculate the difference between two fields - because it recalculates the value whenever any of them changes 

But if to use a custom field for managing a number of days as a difference from somedate up to now, then the value should be recalculated on the daily basis

I see the following options to get up-to-date value daily:
1) with a custom scheduler job  - writing a custom job is customization with code - if you are a developer
2) employ a SugarBPM process definition to recalculate the numbers daily (in an endless loop via waiting for 1 day) - this approach may lead to numerous processes running simultaneously, so should be checked 
3) use Sugar Logic (cal field) but recalculate values manually - there is a menu item to recalulate appears in mass operations menu of the list view as soon as any calc field is added to the listview
4) configure logic hook with Logic Builder configuring tool - because it could be set on the scheduler with LB Events extension - with no development efforts

Also, there is an option just to use reports and not to bother about daily recalculations.
However in this case the advantages of the list view (e.g. filtering) are  not available

Yes, this worked! Thank you so much, Brenda.

Glad to hear it, and no problem!

Nice response Brenda