sugarcrm

Calculate the days between two fields in sugarCRM


How to calculate number of days between two date fields of same module without counting the weekends (Saturday and Sunday) using the "Formula Builder" in sugarCRM studio.


Solution

  • An alternative shorter formula to count days between 2 dates is this:

    abs(subtract(daysUntil($datefieldA),daysUntil($datefieldB)))