3766070 - How to calculate number of days between two dates excluding the start and end date

• Calculate the total number of days between two dates excluding the start and end date
• Calculate and auto populate the total number of travel days using the logic: Travel Days = (Business Start Date - Departure Date) + (Return Date - Business End Date)

• SAP SuccessFactors HCM Suite
• Metadata framework

To calculate the total number of days:

1. Use the function: CalculateDurationInSecondsBetweenTwoDateTimeValues()
2. Divide the result by 86400 to get the actual day difference excluding the start and end date
3. This will also give you the total number of travel days as per the logic: Travel Days = (Business Start Date - Departure Date) + (Return Date - Business End Date)

• KBA 2346811 - How To Configure A Custom Field To Display Absence Duration Based on Calendar Days - SAP for Me
• Get Number Of Calendar Days() | SAP Help Portal
• Calculate Duration in Seconds Between Two DateTime Values() | SAP Help Portal

sf, sap, successfactors, travel, travel days, calendar days, mdf, duration between dates, total days, excluding start date, excluding end date , KBA , LOD-SF-MDF , Metadata Framework , How To