You need to sign in to do that
Don't have an account?
Sujit Karande
Check the date is 1st day of month and set the value
Hi All,
I have a Date field in opportunity object say "Renewal Date"
I want to create a formula field say "Final Renewal Date"(Because it needs to add into the report to show the final renewal date for existing opportunities)
What I am trying to achieve is
If (Renewal Date == 1st day of month) // For eg : 1 Aug 2018
{
Final Renewal Date should be last day of previous month // It should be 31 July 2018
}
else
{
Take renewal date as it is to the Final renewal date
}
Can we achieve this? It's so urgent, I stuck completely. Please help me :(
I have a Date field in opportunity object say "Renewal Date"
I want to create a formula field say "Final Renewal Date"(Because it needs to add into the report to show the final renewal date for existing opportunities)
What I am trying to achieve is
If (Renewal Date == 1st day of month) // For eg : 1 Aug 2018
{
Final Renewal Date should be last day of previous month // It should be 31 July 2018
}
else
{
Take renewal date as it is to the Final renewal date
}
Can we achieve this? It's so urgent, I stuck completely. Please help me :(
But how should we assign Last day of the month to Final Renewal Date after checking for the 1st day of the renewal date
I am assuming that RenewalDate__c is the date field with the initial Renewal Date that is used to determine the final renewal date.
What I shared was the syntax to use in defining the formula.