In my SharePoint 2013 I have 4 columns Start Date (date only), Start Time (Single line of text, max 5 characters), End Date (date only) and End Time (Single line of text, max 5 characters).

I want to come up with a List validation formula that will say: If End Date is equal to Start Date then End Time must be greater than Start Time and if End Date is greater than Start Date then End time can be any time.

I have the same rule in nintex form now I want to apply it in a List so when the users decide to use datasheet view the same rule will apply.

1 Answer 1


I think you should use date time column. It will be much easier than this. You can refer to following link. SharePoint 2010 and SharePoint 2013 will be similar for column validation.

refer this link

  • That was my first option but seconds increments in 5s, in date and time control that is why I ended up date and time column for Date and a single of text for Time.
    – Nosipho
    Jan 16, 2017 at 11:06
  • You can not refer to another column in the same list with validation formula. What about InfoPath forms? I guess you can do this using InfoPath form and rules.
    – newbie
    Jan 16, 2017 at 12:55

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.