-
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
Top 4 Salesforce Spring ’21 Features for CPQ
Hello Salesforce lovers! Salesforce is releasing its most awaited Spring ’21 release. Today, we will shed light on some of the major changes and features added to Salesforce CPQ in this…
How to Maximize ROI with a Salesforce Consultant: Tips and Strategies
When it comes to CRM solutions, Salesforce is a powerhouse, offering extensive features that can propel any business forward. However, to truly leverage the full…
Industry Best Practices to Implement Salesforce Marketing Cloud
The Salesforce Marketing Cloud is a sophisticated technology developed by Salesforce that automates the marketing of a business across a variety of channels, including but…
Popular Salesforce Videos
Transform the Consumer Experience - Salesforce Customer 360 Guide
The Transform the Consumer Experience Customer 360 Guide helps you: Unlock & unify data Personalize digital journeys Go direct to consumers Scale service across channels…
Tips to Crack the Salesforce Administrator Certification Exam in One Go
Do you want to become Salesforce administrator certified? So in this video Shrey has shared the important topics to crack the Salesforce Administrator Exam. Following…
Salesforce App Builder Training | Salesforce App Builder Tutorial | Intellipaat
In this salesforce app builder tutorial, you will learn what is Salesforce CRM, a Sales rep in Salesforce, various user settings in Salesforce, and how…
