I am trying to create a formula field to set a DateTime value, but it fails with the following error:
Error: Incorrect parameter type for function 'IF()'. Expected Number, received DateTime
The formula I am trying to construct is as follows:
IF(MQL_Date__c < First_Sales_Activity_Logged__c, First_Sales_Activity_Logged__c-MQL_Date__c, MQL_Date__c)
MQL_Date__c - Date/Time
First_Sales_Activity_Logged__c - Date/Time
Formula Field - Date/Time
Only if MQL_Date__c is less than First_Sales_Activity_Logged__c than set the formula value to First_Sales_Activity_Logged__c-MQL_Date__c else MQL_Date__c
First_Sales_Activity_Logged__c-MQL_Date__c
, what do you mean by that ? Do you need the difference between dates ?