-
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
- [adinserter block='9']
-
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
Best Practices of Apex In Salesforce - Here's the Complete Guide
Please follow these Salesforce Best Practices to improve our code Quality, Readability, and Reusability. Also, you can use Salesforce Best Practices to optimize our code.…
Salesforce Spring ’20 Release Notes - Top Features
Salesforce Spring '20 Release have been made universally accessible on February 17, 2020. The Spring '20 discharge conveys extended advancements over the whole Customer 360…
Future of Salesforce: Top 6 Predictions
Salesforce is one of the top 10 software skills trending this year. It was the first software of its kind and one of the most…
Popular Salesforce Videos
What are Salesforce Editions and Pricing in Details?
Salesforce Editions and Pricing - Salesforce are providing four types of licenses Essentials, Professionals, Enterprise and Unlimited. Watch the video and if you have any…
Password Protect Records in Salesforce
Suppose Salesforce org record level access is set to Public Read Only and now business want to restrict few records visible to only those users…
101 Guide to IBM Watson and Salesforce Einstein
In March 2017, IBM and Salesforce announced a global strategic partnership to seamlessly connect predictive insights found in unstructured data from IBM Watson APIs to…
