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
Kelly Kanches 6Kelly Kanches 6 

I'm bad with this...need help. Validation rule on date fields

I don't know why I can't seem to "get" this. I've tried so many things and can't seem to logically think through it today.
I have a field Check_Out_Date__c
If this field is completed I need this field Expected_Check_In_Date__c to be required.
I know this is simple but I can't seem to get it today.
Thanks so much!!
Kel
Best Answer chosen by Kelly Kanches 6
Jithin Krishnan 2Jithin Krishnan 2
Correct me if I am wrong. Your requirement is 'If  Check_Out_Date__c is filled, Expected_Check_In_Date__c is mandatory'. If this is what you want, you can create a validation rule like below: 
 IF(ISBLANK(Check_Out_Date__c) ,false, ISBLANK(Expected_Check_In_Date__c))

Thanks.

All Answers

Jithin Krishnan 2Jithin Krishnan 2
Correct me if I am wrong. Your requirement is 'If  Check_Out_Date__c is filled, Expected_Check_In_Date__c is mandatory'. If this is what you want, you can create a validation rule like below: 
 IF(ISBLANK(Check_Out_Date__c) ,false, ISBLANK(Expected_Check_In_Date__c))

Thanks.
This was selected as the best answer
Kelly Kanches 6Kelly Kanches 6
Thank you so much! That worked perfectly! I appreciate it so much!