Sign Up ›

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

Compare two date fields only if one of the date fields is NOT blank.

Trying to write a formula that compares two date fields only if one of the date fields is NOT blank.

Here is what I have so far.
IF(
Last_Sales_Call__c  >  Last_Telephone_Sales_Call__c,"Yes","No")

Basically I need the formula to compare Last Sales Call vs Last Telephone Sales Call only if the Last Telephone Sales Call is NOT blank.
Best Answer chosen by Rung41
badibadi
IF( NOT( ISBLANK(Last_Telephone_Sales_Call__c)), IF( Last_Sales_Call__c > Last_Telephone_Sales_Call__c,"Yes","No"), "No" )

The formula shows "No" if the Last_Telephone_Sales_Call__c is blank. 

All Answers

badibadi
IF( NOT( ISBLANK(Last_Telephone_Sales_Call__c)), IF( Last_Sales_Call__c > Last_Telephone_Sales_Call__c,"Yes","No"), "No" )

The formula shows "No" if the Last_Telephone_Sales_Call__c is blank. 
This was selected as the best answer
Rung41Rung41
Brilliant! Thank you!!1