I want the error message to throw if any of the TEXT address fields are completed but the Multipicklist field (Reasons for 201) does not include "Address Change". But it is not working.
NOT(INCLUDES( Reason_for_201__c , "Address Change")),
OR(NOT(ISBLANK( Street_Address__c )),
(NOT(ISBLANK( City__c ))),
(NOT(ISBLANK( State__c ))),
(NOT(ISBLANK( Zip_Postal_Code__c ))),
(NOT(ISBLANK( Country__c ))),
RecordTypeId = "012C0000000GBZX"
I need to place a validation on one of my date fields in a Customs Object.
The following validation is required:
Lets say, the date today is 4-June-2012.
I need to place a validation where if the user selects any date lesser than 1-May-2012 the system should prompt a message on the field stating that the "Update can be done for current and previous month only".
Which means that to create a record the date selection has to be within the current month and the previous month.