+ 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

SurekaSureka
Hi,

Try this - ISBLANK(Date_Paid__c)
ManjunathManjunath

Hi,

 

Try this

 

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

 

Regards,

Manjunath