I am not able to use correctly validation rule please help me....
When Status is Not-Confirmed: Room No. shouldn't be selected otherwise room no is must. And Check In and Check out time should be empty.
If Status is Confirmed Room No is must And Check In Time and Check Out Time must be empty.
If Status is Check In Room No is must and Check In Time can't be empty. And Check out time must be empty.
If status is Check Out Room No is must and Check In and Check Out Time can't be empty.
And Check Out time must be greater than check in time.
Check In Time
Date/Time Check Out Time
Date/Time Room No
Room_No__c Number(15, 0)
IF(ISPICKVAL( Status__c ,"Not Confirmed"), ISNULL( Room_No__c),False)