-
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
Salesforce Mulesoft Robotic Process Automation: Use Cases and Benefits
Businesses constantly seek to boost digitalization, but time-consuming manual tasks bog down many standard workflows. Automation is especially valuable for organizations with multi-step processes that…
Salesforce Visual Composer – Populate any PDF with Salesforce Data
There are many uses case that will require your customer to manually sign a Document, few examples are: NDA, Contract or Power of Attorney. In…
Salesforce and Slack AI: A Synergistic Partnership
Salesforce and Slack, two industry-leading platforms, have formed a powerful alliance to revolutionize the way businesses operate. By integrating AI capabilities, this partnership offers a…
Popular Salesforce Videos
Schedule Apex Jobs with Lighting Web Components | Developer Quick Takes
Lightning Web Components gives you the ability to give your users a great user experience when interacting with Salesforce. In this example, we will take…
Salesforce Editions Explained
In this video, we break down the Salesforce Editions—Essentials, Professional, Enterprise, and Unlimited—to help you understand which one is best for your business. Whether you're…
How to Test Your Process Builder | Salesforce
In this video, Appopedia provides helpful tips on how to test your process builder in Salesforce. She explains how to create a test user, what…
