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:


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

1 Answer 1


This will do:


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, 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
    May 9, 2017 at 15:24
  • Great. Good to know it worked. May 9, 2017 at 15:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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