You need to sign in to do that
Don't have an account?
Vidhi
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
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