2

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

4

This will do:

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

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

  • Hello thanks for your answer, its not working, it may be because is a date field? – Juansei May 9 '17 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 May 9 '17 at 15:24
  • Great. Good to know it worked. – SharePointer May 9 '17 at 15:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.