Hi guys I just want to get total no of days spent in between the dates,
project_completion_date__c is date field and converted to datetimevalue as created date is
DATETIME datatype. Here is my formula it's throwing following error
Incorrect argument type for function 'ISNULL()'
Any one have an idea about this error?
IF(ISNULL(Project_Completion_Date__c), (Now() - CreatedDate), IF(NOT(ISNULL(Project_Completion_Date__c <> NULL)),(DATETIMEVALUE(Project_Completion_Date__c) - CreatedDate), 1) )