-
How can I know the Day of the Week of a Date in Salesforce?
How can I know the Day of the Week of a Date?
-
2 Replies
-
Hi Ravi,
In SOQL, use the "DAY_IN_WEEK()". It returns a number representing the day of the week for a date field.
In formula field, you can use this:
CASE( MOD( Date_Field - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")Thanks
-
Try this:
CASE( MOD( Date__c - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")
Log In to reply.
Popular Salesforce Blogs
Our Top Picks From Salesforce Summer' 21 Pardot Updates
Another warm summer. Another feature-packed update by Salesforce. How do you make a good thing great? Simple. Provide meaningful, easy-to-implement updates and that is precisely…
A Nonprofit's Success with Salesforce
Case Study: Nonprofit Organization Leverages Salesforce for Growth Organization: The Community Foundation Challenge: The Community Foundation struggled to manage donor relationships, track donations effectively, and…
Salesforce Spring Release ‘24: Features Overview
As you know, Salesforce releases updates three times a year, adding features for developers and making improvements or innovations to Salesforce. The innovations vary, for…
Popular Salesforce Videos
Geocoding and Reverse Geocoding in Salesforce | Google Maps APIs
In this video, you will learn to use Geocoding and Reverse Geocoding service in your Salesforce Org. Geocoding is the process of taking input text,…
Salesforce Einstein Prediction Builder and Einstein Next Best Action
Salaesforce Einstein Prediction Builder is a declarative tool that helps fast-track predictions based on Salesforce fields. This will help a Salesforce admin to custom-build predictions…
How To Use Trailhead To Become A Salesforce Developer
Trailhead is the fun way to learn Salesforce. In this session we'll show you how to leverage Trailhead to quickly and easily learn Salesforce and…
