Search

salesForceMann

<admin<pseudoDev

Tag

date

The ultimate Salesforce formula to add business days to a date (part-2)

In the previous post we saw how we can add business days into a date to get a new date. This was posted here. In this post, we will do the same thing but a bit more cleverly. The logic:... Continue Reading →

The ultimate Salesforce formula to add business days to a date (part-1)

Lets says we have a date, call it Just_a_date__c And we have number of business days, call it Number_of_business_days_to_add__c Business day in this context means Monday to Friday (gosh thank god for a 5 days working week for me and... Continue Reading →

Add days to a date excluding weekends i.e. Saturday and Sunday

Requirement: I have one date field called "Billing date" and one Number Field called "Billing Delay". I want to update one Date field "DueDate" which computes "Billing date"+"Billing Delay". While Computation It will Exclude the Saturday and Sunday! Simple solution:

Powered by WordPress.com.

Up ↑