-
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
How to Enable Einstein Chat Bot in Salesforce | The Developer Guide
What is Embedded Chat? Embedded chat windows use a Chat deployment that you can quickly configure. Then, simply add the code snippet to the web…
Retrieve picklist value of a Record Type using MetaData Service in Salesforce
Picklist values are able to see using standard UI of sObject then field name and then record type name. What if we want to see…
Salesforce Data Migration Process
Best Practices for Data Migration The process of migrating data in Salesforce Project appears to be an easy task for Salesforce Developers but it’s not…
Popular Salesforce Videos
Salesforce - How Small Businesses Offer Great Customer Service
Small businesses are more than capable of offering great customer service, even without having a big call center or multiple service agents on hand. For…
Share Visualforce Pages Between Classic and Lightning Experience | Salesforce Trailhead
Visualforce Pages should be created correctly such that they behave properly whether they run in Salesforce Classic or Lightning Experience. Detecting and Responding to the…
Mocking Apex Tests: Salesforce Tutorial
In this Video Leonardo Berardino talks about the following: Mocking Apex Tests and Apex Mock Examples Unit Tests x Integration Tests How to create unit…
