You need to sign in to do that
Don't have an account?
Ramk123
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
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
I guess one of the field used in this formula is of datetime type in target org.
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.