-
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 Does a Salesforce Developer Course Include?
Since its inception, Salesforce has been the most renowned CRM platform provider in the world. This is due to the robust nature of an ecosystem…
Low-Code/No-Code Development In Salesforce And The Rise Of The Citizen Developer
In today's fast-paced digital landscape, businesses are constantly seeking ways to accelerate innovation and adapt to evolving customer needs. Traditional software development, with its lengthy…
Mobilizing a Visualforce page using jQuery Mobile
In today's mobile world, users today expect nearly the same, if not better, level of access to the same applications and data on their mobile…
Popular Salesforce Videos
Salesforce Training | Salesforce Jobs For Beginners Video
Salesforce Training Tutorial video provides What is Salesforce and Salesforce jobs and Salesforce careers for beginners. So if you are planning to becoeme a Salesforce…
Salesforce Anywhere: Technology Enabling the All-Digital, Work-From-Anywhere World
While companies, governments and organizations are slowly returning to their offices, the COVID-19 pandemic has changed the future of work forever. In fact, nearly 70…
Explore Record Triggered Flow | Learn Salesforce Lightning Flows | Flow Builder Videos
Creating or updating a record can trigger an auto-launched flow to make additional updates to that record before it's saved to the database. A record-triggered…
