-
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
Learn All About the Lightning Web Components in Salesforce
Why Lightning Web Components (LWC)? As of now, the AURA framework which was used for Lightning Components is outdated and it was time for a…
What are the Functions, Benefits, and User Reviews of Salesforce? | Salesforce 101
No doubt you've heard a lot about Salesforce CRM lately. But Salesforce seems to be something huge, something confusing, and turns out that it's not…
What is Salesforce Hyperforce and Why it is Important?
The core of the many Salesforce Clouds is unified by the new infrastructure design known as Hyperforce, which Salesforce released. Salesforce instances may be launched…
Popular Salesforce Videos
What benefits Salesforce Email integration provides for my business?
This video puts light on the benefits of Salesforce Email Integration for Business. Every aspect of Email Integration is provided and discussed in detail along…
How to Use Product Rules with Salesforce CPQ
In this demo video, you'll learn about the three most popular types of product rules for CPQ: validation, alert, and selection. You'll also see how…
Set Your Sales Cloud Implementation Up for Success
Make Sales Cloud a valued business tool that your sales reps will rely on by starting with these planning strategies and best practices for success.…
