+ Start a Discussion
Ramk123Ramk123 

Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime

Hi,

I have created below formula field to calculate total efforts and calcuating as expected, but while deployement am getting below error.

Formual field: 
TEXT(ROUND(
if ( And( TEXT(Status) <> "Completed", TEXT(Status) <> "On Hold",
ISBLANK(Task_Completion_Date__c), ISBLANK(On_Hold_Date__c )), NOW() - CreatedDate,

if( TEXT(Status) = "On Hold", On_Hold_Date__c - CreatedDate,

if( TEXT(Status) = "Completed", Task_Completion_Date__c - CreatedDate - (Not_On_Hold_Date__c - On_Hold_Date__c),

NOW() - CreatedDate - (Not_On_Hold_Date__c - On_Hold_Date__c))))*24, 2))&" "&"hours"

Deployment Error  : Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime

Appreciate your help at the earliest.

Thanks,
Ramesba
Karan Shekhar KaulKaran Shekhar Kaul
Hi,

I guess one of the field used in this formula is of datetime type in target org.
Ramk123Ramk123
Thanks for the quick response!

Yes, I used below Data/time type field to calculate hours.

Custom Fields created with Data/Time type field.
Task_Completion_Date__c
On_Hold_Date__c
Not_On_Hold_Date__c.