-
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
What are some benefits of implementing Salesforce as a SaaS CRM?
Introduction Salesforce is a cloud-based customer relationship management (CRM) software that many organizations use to manage their customer data, sales, and marketing activities. It is…
Salesforce Product : Community Cloud
Salesforce Product: Community Cloud Community Cloud can determine either a portal, a help forum, a support site, HR central, or something else, an online community…
Integrate Your Vanilla-Community With Salesforce to Deliver Seamless, Efficient Support
According to a survey conducted by Gartner, 62% of millennials and 75% of GenZ customers prefer self-service instead of seeking assistance from support reps. As a result, online…
Popular Salesforce Videos
Winter '21 Release | Salesforce Tutorial Video
The Sandbox Preview window for Winter '21 begun on September 11, 2020. You must have an active sandbox on a preview instance before then to…
Salesforce Pardot: 2020 Update
If you’re a current Salesforce user, you may be hearing a lot about Pardot these days. Perhaps you are using MailChimp, Campaign Monitor, or Constant…
What Is Loyalty Management in Salesforce? | Video Tutorial
In the past few years, we have come across terms such as loyalty programs and loyalty management. Let's understand the concept of loyalty management with…
