Need to create a formula to calculate number of days between two date fields across objects.
I have created a formula field to calculate the number of days between two date fields:
Date Type = formula
Result = Number
dummy__r.dummy_date__c - DATEVALUE( CreatedDate )
But this formula is not providing a value.
You are correct - Looking at the SFDC Object reference, Case.closedDate is a DateTime field so line 2 and line 4 will break
Looking at line 2 and line 4 - these are manipulating days, not seconds so I'd rewrite line 2 and line 4 as:
Line 2
( 5 * FLOOR( ( DATEVALUE(ClosedDate) - DATE( 1900, 1, 8) ) / 7) +
Line 4
MOD( DATEVALUE(ClosedDate) - DATE( 1900, 1, 8), 7) +
You should go to the doc and use the feedback form to point this out to SFDC
I think your approach is right, but you should use only 2 decimal places in your formula number field.
I have tested the following:
NOW() field (DateTime formula) NOW()- ut__Datetime__c (number formula, 2 decimal places)Works well:
Best Answer
Formula =
(FieldValue1) - (FieldValue2).You have to ensure that the
FieldValue1andFieldValue2are of same type i.e.