-
Formula to show if date field is within first half or second half of the month?
Hii All,
Please help in writing formula to show if date field is within first half or second half of the month.
-
1 Reply
-
Hi Tanu,
First make a custom field ( dateTest__c) of Formula Type and Formula return Type is Text then apply this formula
Formula:
IF(DAY( dateTest__c)>=15,
(CASE(MONTH( dateTest__c), 1, "January", 2, "February", 3, "March", 4, "April", 5, "May", 6, "June", 7, "July", 8, "August", 9, "September", 10, "October", 11, "November", 12, "December", "None") & " - " & "Second Half"),
(CASE(MONTH( dateTest__c), 1, "January", 2, "February", 3, "March", 4, "April", 5, "May", 6, "June", 7, "July", 8, "August", 9, "September", 10, "October", 11, "November", 12, "December", "None") ) & " - " & "First Half")Formula will return the result August - First Half or August - Second Half.
Please remember to replace dateTest__c with the API name of your custom date field .
Hope this helps you.
Log In to reply.
Popular Salesforce Blogs
The Need for the Right Salesforce Lightning Expert
Salesforce is one of the world’s leading CRM platforms, helping businesses enhance their sales, marketing, and customer service. Its wide range of features and tools…
3 Hot Trends Secretly Pointing towards Future of CRM
Customer Relationship Management or CRM is the future of the business and is not going to fed so soon. Starting from small businesses to the…
Top New Salesforce CPQ Summer ’20 Release Features
Hello everybody! The Salesforce Summer ’20 feature releases have been scorching the tracks this summer, and we’ve thoroughly enjoyed writing the reviews for each of…
Popular Salesforce Videos
How to Delete Preloaded Sample Data in New Salesforce Organizations
When Users begin a trial or subscription with Salesforce, their org comes with a set of sample data. This data includes Accounts, Contacts, and Opportunities.…
Salesforce for Manufacturing: How to Digitize Your Sales Processes
As a manufacturing sales leader, you’re looking for ways to go digital with your sales processes and improve channel performance. In this video, you’ll learn…
How To: Build A Salesforce Career with This Tool!
Timecodes 0:00 - Intro & Overview 0:57 - Talent Stacker 3:00 - Career Progression 10:08 - Flow is the Future 13:36 - Learn More/Outro If…