+ Start a Discussion
VidhiVidhi 

Date formula field

Hello friends,

 

I am trying to make one formula field based on one date field. My all the field in the formula are date field. It is executing the false part but for true part of the if it is not working.

 

IF( Date_Paid__c = Null, TODAY()- Invoice_Date_Capture__c , Date_Paid__c - Invoice_Date_Capture__c )

 

My  Date_Paid__c - Invoice_Date_Capture__c is giving value but TODAY()- Invoice_Date_Capture__c is not giving value 

 

Thank in advance

sandeep@Salesforcesandeep@Salesforce

Hi Nidhi, 

 

Please use this 

IF( ISNULL(Date_Paid__c), TODAY()- Invoice_Date_Capture__c , Date_Paid__c - Invoice_Date_Capture__c )

 

This works perfectly. 

 

Please give kudos if I resolved your problem