I need to calculate the difference in minutes between two datetime fields inside a formula.
The following works if the dates are different
(date2__c-date1__c)*24*60
But if its the same date then this fails as the difference between the two values subtracted from each other is zero.
Is there an easy solution to this?
Text
and formula will beTEXT((date2__c-date1__c)*24*60)