-
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
5 Things To Know Before Implementing Salesforce Sales Cloud
Salesforce Sales Cloud is a Customer Relationship Management (CRM) platform that helps enhance the efficacy of the sales team of an organization and increase sales revenue.…
Salesforce Lightning Aura Components Core Concepts
Page & Bundle Visualforce pages (and Visualforce additives, but permits’s set those apart for now) are saved on Salesforce as a single entity, an ApexPage.…
How to Use Map In Lightning Component?
For using the map in the lightning component, we need to define the attribute of the type map to hold key-value pairs. In this blog,…
Popular Salesforce Videos
Salesforce Tutorial - Creating Custom Object
Many times, New Salesforce Developers don’t understand from where to start it. In this video, I have shown the way exactly to create a Custom…
How UiPath Robots Upload Files to Salesforce
How #UiPath Robots upload files to #Salesforce and assign to #Case without custom activity just RAW REST API. 0:00 Preview0:55 Intro1:20 Logic in one picture1:38…
How to Find Volunteer Work as a Salesforce Professional
In this video, Brad discusses how to generate work experience through volunteer jobs. These jobs allow for new professionals to gain Salesforce specific, applicable knowledge…
