Skip to main content
We sell licences, when we add the product (which falls under a licencing product family) we need to ensure that users enter a start date and end date (these are two separate fields).

 

Currently this is the rule I have used

 

AND(TEXT(Product2.Family) = "Licencing",

 

OR(

 

ISBLANK(ServiceDate)),

 

ISBLANK(Licence_End_Date__c))

 

Problem with this rule, is the product can be added to the opportunity, if ONE of the date field has a value, but it should be that the product is added to the opp ONLY if BOTH date fields have a value.
2 Antworten
  1. 29. Dez. 2013, 16:44
    AND(TEXT(Product2.Family) = "Licencing",

     

    OR(

     

    ISBLANK(ServiceDate),

     

    ISBLANK(Licence_End_Date__c)))

     

    Check this out 

     

    if our suggestion(s) worked,  let us know by marking the answer as "Best Answer" right under the comment.This will help the rest of the community should they have a similar issue in the future.  Thank you!

     

    Shivanath