-
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
Apex Integration in Salesforce - The Developer Guide
This article closes the arrangement, Learning Salesforce Integration, which subtleties different joining choices with Salesforce. It covers utilizing Apex for building incorporations, which turns into…
The Benefits of Salesforce Sales Cloud for your Business | The Ultimate Guide
In today’s competitive business environment, customer satisfaction and retention are key factors in achieving success. This is where Salesforce Sales Cloud comes into play. It is a…
Salesforce Commerce Cloud for E-Commerce
What Is Commerce Cloud? Commerce Cloud is one of the eight product clouds that make up the Salesforce Intelligent Customer Success Platform. Along with Sales…
Popular Salesforce Videos
Introduction To Salesforce Apex | DataType | Collection | Conditional Statements
In this video salesforce apex hours creators provides an introduction to Apex. Apex enables developers to access the Salesforce platform, back-end database and client-server interfaces…
Mastering Apex Collections | Salesforce Tutorial
Working with collections like List, Map and Set is part of the day’s routine for Apex developers. While their basic use is straightforward, there are…
What is Salesforce in Simple Words | Who Can Learn Salesforce
What Exactly is Salesforce, Why is Salesforce CRM tool most demand in the IT market nowadays, Who can learn Salesforce course, what is the average…
