-
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
Quote Templates in Salesforce: What Do You Need to Know to Use Them Right
The C, P, and Q in CPQ stand for Configuration, Pricing, and Quote—a powerful combination that simplifies the proposal process. Creating accurate and professional-looking quotes…
MuleSoft, the Integration Platform You Need | Salesforce
Normally, most companies use some type of software to carry out their business process management and administration. On many occasions, they use several different software,…
Salesforce Automation Tools - Which Tool You Should Use
Automation Tools: Salesforce automation software is a set of programs that help in automating business processes. Automation tools are one of the declarative gears in…
Popular Salesforce Videos
Apex Performance Tips and Tricks | Salesforce Video Guide
Watch this video to learn all about Apex Performance: • What do we mean by performance? • How do we measure performance? • Loop Performance…
Create Survey in Salesforce | #Feedback Program #Salesforce Tutorials | Mini Project
In this video you will learn : What are the surveys? Why businesses use surveys? And how you can create and send surveys using #Salesforce? …
Client Side Search in Lightning Component Salesforce | Lightning Data Table
In this video, I will implement the Client-Side Search functionality in Lightning Data Table in a Custom Lightning Component. Client-Side Search allows users to search…