on 07-01-2011 4:29 PM
Hi,
I have a field named as Actve (Type: Boolean)
Boolean values are..
True = Y
False = N
I have 2 date fields, activation date and End date.
Now my requirement is When the Active =Y Then BOTH the date fields SHOULD have value AND IF EITHER OF the date fields have value then Active Field Should have a value..
Is validation possible on a Boolean field??
I tried a validation but it did not work, It works only for the first part and not for the later..
Can anyone help..
Kind Regards
John
Hi John,
I hope the below validations should work:
If (Active=True, Is Not Null (Date1) And Is Not Null (Date2))
If (Is Not Null (Date1) OR Is Not Null (Date2), Is Not Null (Active))
Best Regards,
Dheeraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.