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
Radhika pawar 5Radhika pawar 5 

Validation Rule

Hi Frnds,

I want  validation rule on attendance fields is cannot greater that camp1 duration
I m Doing:
I m inserting the Value in Camp1 start date is 1/8/2014 end date is 10/8/2014 ther Duration be 10 days
I m doing this code :
OR((CMP1_To__c-CMP1_From__c)<VALUE(TEXT(VTI_AD_CMP1_T1__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T2__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T3__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T4__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T5__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T6__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T7__c ) ),
(CMP1_To__c-CMP1_From__c)<VALUE( TEXT(VTI_AD_CMP1_T8__c ) ))
It will show validation msg if i m selecting 12 days.
but if i m selecting 10 days Duration on Attendace fields then there is also show validation msg.

Plz Guide me below Requirement:
I want validation on Attendace fields  if i m selecting 10 day then they will not showing Error msg.


srikanth sfdcsrikanth sfdc
u can use this by using validation rule


IF( End_Date__c > (Start_Date__c +9), true, false)