How to add business days to a date in Salesforce formula ?

Good Post by Force-Base.Com!

ForceBase

Many a times we come across requirements wherein we are supposed to set the due date to a certain number of days from a particular date. Most of the times, organizations insist on setting it to certain number of business days later. This is the point where many admins get stuck figuring out how to add business days to a particular date. I have personally seen many questions asked regarding this in the Salesforce success and developer communities. So thought of writing a post on the same which might help these folks if they have to setup something similar in the future.

Suppose you want to set it to 14 days after a certain date and if you simply add 14 to the value of a date field, Salesforce formula will also include the weekends by default. So how do we override this ?

Well, to do that we need…

View original post 497 more words

Advertisement

Use Trailhead to get Salesforce Admin Certified

Looking to get Salesforce Certified, and wondering where to start the preparation?  There are Study Guides for Salesforce Certification but they only talk about the topics the certification covers and their corresponding weight-age of each topic. And then there is Trailhead - The fun way to learn Salesforce.  But how can we connect these both, the …

Salesforce Einstein – Coming This Dreamforce’16

Dreamforce 2016, the Salesforce's Largest Annual Conference to be held in October, will unveil a product called Salesforce Einstein!  Benioff announces a big product or two every year at Dreamforce, but Einstein is something different. “If this is not the next big thing, I don’t know what is,” says Marc Benioff, the CEO of the world’s …

Salesforce Trailhead Profile Widget

I have designed this little Trailhead Profile Widget that has trail head stats.  As Salesforce Trailhead freaks, I thought there should be a consolidated stats of the trailhead modules we complete.  Here's the one I designed This can be treated more like a "digital business card of your trailhead profile".  It  has the name (or an …

Lightning Navigation Menu – Change is Coming

If you are using Lightning Experience in your Salesforce instances, then by now you must be familiar with this view, the navigation menu on your left side.  The menu that holds all your tabs and helps in navigating you to different objects.  Now that is changing! Yes, the vertical navigation menu is changing.  It will no …

Visualforce Pagination with Dynamic Search

This post has a working example of dynamic search in a Visualforce page and the results shown with pagination. There are 4 field search criteria including date fields too which makes it more interesting.  The results upon clicking Search will display below the Search section with 4 buttons to paginate.  The Next/Last Page buttons grey …

Salesforce E-Commerce Cloud

Salesforce could soon introduce a brand new Cloud to it's wide variety of growing cloud platforms.  We already know, during Dreamforce 2015, Salesforce introduced a new cloud, IoT Cloud to its feathers. Today (June 2016), with the acquisition of a Twelve-year-old company Demandware which provides an enterprise-class cloud commerce development platform, Salesforce would soon step into an area which …

Salesforce Technical Architect Certification Update

Finally this month (May 2016), Salesforce has released more details on 3 of the Domain Specialist Certifications Exam details and made the 3 exams ready for the public to grab!

Quick Tip – Change Date format in Apex

If you use any date fields in Apex, it prints in this format System.debug('Date: '+contact.Date); Output:  2016-04-26 00:00:00 To change the format you can simply use: format() System.debug('Date: '+contact.Date.format()); Output:  26/04/2016  

Awesome Global Picklists

Update: This article was written when Global Picklists was launched.  Salesforce has now renamed Global Picklists to Picklist Value Sets.   Do you want to use same pick list values in different objects across the system?  Global Picklists is your answer! Global Picklists lets you efficiently reuse a single list of values for multiple custom picklist …

Run Script After Sandbox Creation and Refresh

This feature is to make your sandbox environment business ready, automate data manipulation or business logic tasks or even to schedule your jobs. At sandbox creation, specify a single Apex class to perform the tasks. This class executes every time the sandbox is refreshed/copied. Create an Apex class that implements SandboxPostCopy and specify the class here. For example, the …

Salesforce Halloween Special Trail Head Badge

Salesforce added a new community trail head badge for this Halloween called "TrickOrTrailHead". Earn the Trailhead badge this Halloweekend for a Spooktacular surprise by completing this simple Admin module with 3 topics.  

Dreamforce Wrap Up 2015!

Attended Dreamforce this year, my first time in forever and its been an awesome experience with great learning.  Travelled all the way from Singapore to San Francisco and Dreamforce didn't disappoint a bit.  This time Dreamforce is bigger than before with whopping 1,70,000 user registrations and 1600+ sessions and some rock entertainment in the Dreamfest (the Dreamforce …

Wrapper Class Multiple Value Sorting

Came across a scenario where I had to sort a wrapper class.  Normal list sorting is simple, list.sort(); would help.  But for a wrapper class, it's not straight-forward but it isn't that hard.  Below is a simple wrapper class without sorting - this wrapper has 2 columns : Area and AD. global class AreaWrapper{ public String …

New UI for Salesforce

Salesforce.com has a completely redesigned version of its core CRM product.  The new version has been designed with a cleaner, more modern looking interface. Here's the previous UI, now being referred to as Classic Salesforce UI And here's the switch to Lightning Experience The new version uses a navigation bar approach, abandoning the tabbed interface of …

Salesforce Introduces New Certifications for Developers

Salesforce introduced 3 new developer certifications for Force.com developers Platform Developer I Platform Developer II Platform App Builder The immediate question is what happens to the existing developer certifications (401 and 501). Well,  you can continue to maintain your Salesforce Certified Force.com Developer credential. However, effective September 14th (2015), Salesforce will no longer be offering this credential …

%d bloggers like this: