Subtracting 2 date values in a report with a formula - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Gregory PoyerGregory Poyer 

Subtracting 2 date values in a report with a formula

Hi all, 

I would like to add a formula into a report in order to show the difference between 2 date values from an opportunity.  For example, RFQ submitted date - oppty created date.

Looking through the Summary fields within the custom summary formula I don't see any of the date fields from the opportunites.  Is there any other way to do this function?

Thanks, 
Greg
Deepak AnandDeepak Anand
You can create a Formula Field on the Opportunity Object like as below:

Formula Field: Time Lapsed
Formula Field Return Type: Number
Formula:
RFQ_Submitted_Date__c - DATEVALUE(CreatedDate)
You can then drag the new field - Time Lapsed as a Column for your Report.
Amitkumar BangadAmitkumar Bangad
+1 Deepak.

Its not possible in report directly as Subtraction can be done only on numeric/currency values. You need to go for Formula field on Opportunity.

Cheers,
Amit