cancel
Showing results for 
Search instead for 
Did you mean: 

Validation on Boolean Field.. Is it possible

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Dheeraj,

Thanks for the Reply, that worked.

Full points awarded.

Kind Regards

John

Answers (0)