Formula Field w/ Time Period

We're currently using the below formula in a formula field to capture sales amount for the last rolling 30 Days.

IF(

AND(Customer_Care_Inquiry__r.Surgery_Demo_Date__c >= TODAY()-30,

Customer_Care_Inquiry__r.Surgery_Demo_Date__c <= TODAY()), Sales_Amount__c ,0)

How can I change this formula to capture sales within a certain date range?

6 Antworten

Amber Gillis (K2M)
17. Sept. 2014, 15:11
Yes, I want summarize the sales from July-Sept 2014 instead of using the TODAY()-30

Kommentar hinzufügen

0/9000

Data Management