Form Validation, if is not blank do validation

Question

Hello i have a list with 2 date columns, [Date1] , [Date2],

How do i excecute the next validation on te list validation, only if that fields are not empty:

=[Date2]>[Date1]]

i want the users can let empty that fields and only validate if the dates are entered. Thanks, im on sharepoint online

P S · Accepted Answer · 2017-05-27 14:12:12Z

4

This will do:

=OR(ISBLANK([Date2]),[Date2]>[Date1])

Basically, save only if 1) Date2 is empty or Date2 value is greater than Date1

P S

4,8174 gold badges28 silver badges50 bronze badges

answered May 5, 2017 at 23:37

SharePointer

3,0461 gold badge14 silver badges28 bronze badges

Hello thanks for your answer, its not working, it may be because is a date field?
– Juansei
Commented May 9, 2017 at 13:52
I found the problem the formula was okay, in my case the separator that works is not coma (','), but semicolon (';'), then the formula doesnt throw sintax errors
– Juansei
Commented May 9, 2017 at 15:24
Great. Good to know it worked.
– SharePointer
Commented May 9, 2017 at 15:27

Add a comment |

1 Answer 1