Skip to main content
Scott Gordon ha fatto una domanda in #Reports & Dashboards
I would like to write a report that does a comparison between 2 different date fields in Opportunities.  We have an estimated close date and an estimated ship date.  I would like to report off any Opportunities that have a Close Date that is greater than the Ship Date to help eliminate data entry errors.
5 risposte
  1. 26 apr 2012, 20:46
    If you want to prevent users from creating Opps where Est. Close Date is greater than Est. Ship Date, create a validation rule.

     

    The Error Condition Formula is: 

     

    Estimated_Close_Date__c > Estimated_Ship_Date__c

     

    Remember, Validation Rules only fire when the formula returns TRUE.