-
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
Unboxing Salesforce Winter ’20 edition| Accelerate the adoption with Salesforce In-App guidance
Along with numerous global events taking place this winter, Salesforce has also released its much-awaited Winter ’20 edition. And, as always, Salesforce has exceeded the…
When is the Right Time to Migrate to Salesforce Lightning Experience?
Oh! You are here, which means you are intrigued and excited about Salesforce Lightning experience. Let’s start with a general question that’s on everyone’s mind:…
An Introduction to Salesforce Consumer Goods Cloud
Salesforce has introduced Consumer Goods Cloud, a new industry product that enables companies related to consumer goods to optimize revenue growth and maximize ROI with…
Popular Salesforce Videos
How to Create Bulk Custom Fields in Salesforce using BOFC App | Salesforce | BOFC | AppExchange
Want to perform multiple operations? This quick video walks you through how to create mass custom fields of any type (Master Detail, Lookup, Formula, Primitive…
Case Management App on Salesforce AppExchange
Is your customer support struggling with customer satisfaction for high service cost? Don't know how to work on right priority cases? Don't worry Algoworks presents…
Salesforce Pay Expectations $$$ US and UK
Do you agree or disagree with these numbers? How do you think Mason Frank could have surveyed differently? In this video, Brad discusses just how…
