Solved

Date validation issue

  • 28 February 2018
  • 3 replies
  • 91 views

Userlevel 2
Badge +9

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:

213679_pastedImage_1.png

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?

icon

Best answer by emha 28 February 2018, 19:15

View original

3 replies

Userlevel 5
Badge +14

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'

Userlevel 2
Badge +9

Ahh, I'm thinking backwards here.  Yep, making that change fixed it.  Thanks.

Setting a date validation s very wise of you as tempering with the date has never proven to be good. Hackers from samedayessay.net have shown recent activity in this region. Everyone should stay safe and disconnect their devices that have sensitive data.

Reply