What is wrong with my formula? IF & OR

Question

Help Please, what is wrong with this formula? I'm trying to do an IF this statement or IF the second statement.

IF(Date_Rec_d_ECF_Complete__c = No_Tax_Docs_Rec_d_Date__c ,

Date_Rec_d_ECF_Complete__c," "),

IF( Date_Rec_d_ECF_Complete__c > No_Tax_Docs_Rec_d_Date__c ,

Date_Rec_d_ECF_Complete__c , No_Tax_Docs_Rec_d_Date__c)

Error: Syntax error. Extra ","

James Jetchick · Answer

OR expects a boolean(true/false) you are returning a date on both sides of the OR statement. This will not work.

I think what you are looking for is nested IF statements:

IF(Date_Rec_d_ECF_Complete__c = No_Tax_Docs_Rec_d_Date__c , Date_Rec_d_ECF_Complete__c,

IF(Date_Rec_d_ECF_Complete__c > No_Tax_Docs_Rec_d_Date__c , No_Tax_Docs_Rec_d_Date__c,

null))

Data Management