You need to sign in to do that
Don't have an account?
suchitra moilla 1
Formula Field Error :IF() Expected Date, received Number
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.
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.
IF you want, I recommend to choose text from costom field type ,and formula
IF((ISBLANK(Evaluation_received_date__c)),TEXT(TODAY()),TEXT(Evaluation_received_date__c - Application_to_evaluator__c))
Please excuse me if you may not understand or you feel bad with my poor English.
All Answers
IF you want, I recommend to choose text from costom field type ,and formula
IF((ISBLANK(Evaluation_received_date__c)),TEXT(TODAY()),TEXT(Evaluation_received_date__c - Application_to_evaluator__c))
Please excuse me if you may not understand or you feel bad with my poor English.