function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dandydandy 

Using Created By date in Validation Rule- logical error

Hi All... I've finally got the syntax to come back valid but the rule isn't perfoming as I hoped. I'm trying to say the following:  you may not move to the following stages if this field is blank but apply this rule only if the record was created after August 1, 2009.  (So that the rule doesn't apply on old records since this field was added to the page layout only in recent years).

 

IF(DATEVALUE( CreatedDate ) > DATE(2009,8,1) ,
and(or( ISPICKVAL( Application_Stage__c , "QA Pre-Underwriting"),ISPICKVAL( Application_Stage__c , "Underwriting"),ISPICKVAL( Application_Stage__c , "QA Pre-Assessment"),ISPICKVAL( Application_Stage__c , "Setup"),ISPICKVAL( Application_Stage__c , "Training"),ISPICKVAL( Application_Stage__c , "QA Post-Assessment"),ISPICKVAL( Application_Stage__c , "Complete")), ISNULL( CC_Submission_Fee__c ), $RecordType.Name ="CC Processing"), 1=1)