I am trying to create a validation rule on a date field -
1. First Check if Count_Stores checkbox is checked
2. Check if a particular set of dates for example 3/30/19 , 4/4//19 and 7/2/19 fall between the count_start_date and count_end_date when the user inputs these dates - then flag an error
Help please..
2 个回答
Try this =
AND(
Count_Stores__c = TRUE,
OR(
AND(
Count_start_date__c <= DATE(2019, 03, 30),
Count_end_date__c >= DATE(2019, 03, 30)
),
AND(
Count_start_date__c <= DATE(2019, 04, 04),
Count_end_date__c >= DATE(2019, 04, 04)
),
AND(
Count_start_date__c <= DATE(2019, 07, 02),
Count_end_date__c >= DATE(2019, 07, 02)
)
)
)
