Hi,

I need to create a new field “Evaluation duration” which is number of days between “Evaluation received date” and “Application to evaluator” fields.  If “Evaluation received date” is null, it should be set as today date in the formula. 

I have used this formula 
IF((ISBLANK(Evaluation_received_date__c)),TODAY(),Evaluation_received_date__c - Application_to_evaluator__c)

But got this Incorrect parameter type for function 'IF()'. Expected Date, received Number

Any thoughts would be of great help.
 

Hi,

I need to create a new field “Evaluation duration” which is number of days between “Evaluation received date” and “Application to evaluator” fields.  If “Evaluation received date” is null, it should be set as today date in the formula. 

I have used this formula 
IF((ISBLANK(Evaluation_received_date__c)),TODAY(),Evaluation_received_date__c - Application_to_evaluator__c)

But got this Incorrect parameter type for function 'IF()'. Expected Date, received Number

Any thoughts would be of great help.