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
prabhakar r 3prabhakar r 3 

formula field date1-date2

formula field date1-date2.if date1 or date2  is not enterd formula fied should display 0.00.please help me
 
mritzimritzi
IF( 
    OR( ISBLANK( Date1__c ), ISBLANK( Date2__c )) , 
    0.00, Date2__c - Date1__c
)

Formula field return type should be number.
Change Date field api names ar per your Org data.

Mark it as Best Answer, if it helps.
Santosh Kumar 275Santosh Kumar 275
Use this in formula field.  
NULLVALUE( Date1__c  -  Date2__c, 0)
If you are satisfied with the answer. Mark this as best answer.