First time poster 🙂
Capture new users, changes to existing users and termination of users.
I have a ValidFrom (set as today by default) date field and ValidTo date field that has 12/31/2099 as the default date entered.
I also have a choice(called Statusofrecord) dropdown with 3 options (Starter/Changer/Leaver).
I'm trying to create a rule that throws an error message with the following conditions
IF Statusofrecord = 'Leaver' & Validto = 12/31/2099 Then Error message.
No matter what I try (without formatting date etc) the rule doesn't apply.
If I remove the Validto part (keeping only Statusofrecord) then the error message appears.
Could someone kindly point me in the right direction, I've been trawling through the forums, youtube and a Lynda.com course to try and find an answer.
thank you to anyone who can help.
Sharepoint is on-premise 2013
Solved! Go to Solution.
Add this as a validation rule to your ValidTo Date control.
Dont just cut and paste this rule, make sure you replace StatusOfRecord etc with your named controls so they turn red.
With the dates I decided to say "if the year is 2100 onwards" its invalid.