-
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
Top Salesforce Spring '23 Customer Data Platform Features
The management and extraction of insights from customer data are made simpler for your digital-first marketing team by a customer data platform (CDP), a piece…
Purpose and Perks of Salesforce Subscription
As a business owner, you know customer relationships are key to success. You also understand that managing those relationships can be time-consuming and expensive. A…
Salesforce Sales Cloud Innovations – Your Key to Higher Revenue
Sales have gone through a tremendous evolution over the years, starting from door-to-door to using advanced technologies. And now they’ve stepped into a hybrid age…
Popular Salesforce Videos
Salesforce FY19 Year in Review
FY19 was our best year yet. With new partnerships and friends, we blazed new trails and continued creating a better future, together. Thank you to…
Revenue Generation Opportunities on AppExchange
If you're an aspiring entrepreneur or a business professional looking to expand your revenue streams, this video is a must-watch! Watch this extract from our…
Salesforce Contact Tracing for Employees Demo
As businesses gradually reopen after worldwide closures, many people feel concerned about the second spike in COVID-19 cases. To ensure public safety, local officials have…
