Ok, I'm trying to setup a date validation to prevent someone from forward dating the control. Essentially the value must be less than or equal to the current date. I've setup a date control and set to Date only. It is connected to a date column in the list. I then created the following rule on the control:
The rule works, but for some reason I cannot put in today's date in my control. It for some reason invalidates the control thus preventing me from saving it. This validation needs to be in place whether or not form is new or edit mode. Am I missing something?
Solved! Go to Solution.
it's because 'Control is invalid if...' formula evaluates to true. so if you supply current date in the control, the formula still evaluates to true.
you should check just for 'lessThan'