I have the following formula to automatically calculate the end date (start_date__c + 3 month) for all products other than "standard".
However I would like to replace the false IF statement right at the end (null) by [ Month(start_date__c) +12 ] but I get an error message: Error: Incorrect parameter for function 'if()'. Expected Date, received Number
I created this validation rule on the opportunity to prevent users creating new opps if the account has not passed credit checked. (one of the business rules)
It works fine but when converting a lead, this rule prevents from converting. The "Do not create a new opportunity upon conversion" box is checked by default, and when unckecking it, the validation rule prevents conversion.
I have been trying to add: AND (ISNEW(), Accountid...... with no luck. How can I make sure that this validation rule only applied when the acocunt is not new.
I need to create a validation rule to ensure leads can be converted even if the address is incomplete.
I have a validation rule on the account preventing it to be saved without an address and need to update it to allow leads to still be converted if part of the address is missing.
I have the following formula to automatically calculate the end date (start_date__c + 3 month) for all products other than "standard".
However I would like to replace the false IF statement right at the end (null) by [ Month(start_date__c) +12 ] but I get an error message: Error: Incorrect parameter for function 'if()'. Expected Date, received Number
I created this validation rule on the opportunity to prevent users creating new opps if the account has not passed credit checked. (one of the business rules)
It works fine but when converting a lead, this rule prevents from converting. The "Do not create a new opportunity upon conversion" box is checked by default, and when unckecking it, the validation rule prevents conversion.
I have been trying to add: AND (ISNEW(), Accountid...... with no luck. How can I make sure that this validation rule only applied when the acocunt is not new.
I need to create a validation rule to ensure leads can be converted even if the address is incomplete.
I have a validation rule on the account preventing it to be saved without an address and need to update it to allow leads to still be converted if part of the address is missing.
