-
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
All About Custom MetaData Types | The Salesforce Developer Guide
Custom metadata is packageable, adjustable, upgradeable, and deployable application metadata. To start with, you make a custom metadata type, which characterizes the type of application…
User Agent Flow in Salesforce | The Developer Guide
User Agent Flow (Mobile App Integration) A simple flow for clients that don't need to include global secrets (such as distributed apps) but can be…
What is Salesforce Net Zero Cloud?
Barely a day goes by without there being something in the news about climate change, sustainability or carbon footprints. It is a major focus for…
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 Field Service: Complex Work and Routing | AblyPro Webinar
Salesforce Field Service is a powerful tool designed to help businesses manage complex field service workflows and optimize their routing processes. With Salesforce Field Service,…
Do you need to learn Salesforce Admin & App Builder if you want to become Salesforce developer ?
5 reasons why you need to learn the Salesforce Admin and App Builder even if you want to become or you are a Salesforce Developer.…
