Hi,

Is it possible to have two conditional operations in column validation? I have these two terms I would like to be valid at the same time:

[DateField1]>Today()-180 OR

[DateField1]<DATEVALUE("01/02/1900") (This means that empty date is ok)

How shoud I write the validation to have these both to be valid as OR operations?

=OR([DateField1]>Today()-180, [DateField1]<DATEVALUE("01/02/1900"))

Hi Supid

That formula looks correct but somehow I still get error message:

"The formula contains a syntax error or is not supported"???

It's ok if I choose only one of those but not both. Have you or someone else managed to use two conditional clauses successfully as a column validation rules? I wonder is it possible at all.

Hi,

From your description, I know you want to use two conditional in column validation.

I have test the method that given by Supid, and it works fine. I test it with these steps below:

1. Click List Settings in the Ribbon.
2. Click Validation Settings under General Settings.
3. Add the formula as the screenshot below.
4. Test it.

The screenshot below is my result.