function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
bhanu_prakashbhanu_prakash 

how to two formula into one formula

I have two formula fields
=================================================
IF(MONTH(Date__c) < 12,
IF(DAY(Date__c) > 10, Date__c, DATE(YEAR(Date__c), MONTH(Date__c)-1,+1)),
IF(DAY(Date__c) > 10, Date__c, DATE(YEAR(Date__c) + 1, 1, +1)))

==============================================================
DATE(YEAR(Date__c), MONTH(Date__c) , 1) - 1

if date is below 10th i need to upate previous date and more than 10th i need to update same day
both above formula doing two functions seperatly i need to make into single formula
 
bhanu_prakashbhanu_prakash
IF(DAY(pse__Date__c) > 10, pse__Date__c,
DATE( YEAR( pse__Date__c), MONTH ( pse__Date__c), 1 ) - 1
)