Salesforce: Adding specific working days to a Date

UPDATE: If you want to consider holidays and business hours you can check out this article.

Many time while coding we come across the requirement in which we need to calculate the EndDate from a StartDate after a specific number of business/working days. That means excluding the weekends (Saturday & Sunday) Following is the code snippet which does this. I know there can be an optimized way of doing this. But I didn’t want to spend more time on this.

Below method takes date and number of working days to be added to the date.

Method daysOff calculates the number of non-working days coming in the start date and end date. And after which we are again adding those number of days.

Salesforce : Converting DateTime to format YYYY-MM-DDThh:mm:ssZ

I spend lots of my time finding a solution for converting the datetime into the format (YYYY-MM-DDThh:mm:ssZ) so that it can be used in SOQL query.  SOSL query returns the datetime in format(YYYY-MM-DDThh:mm:ssZ) so for comparison one need to convert it into that format.


I hope this will save your time. 🙂