I have the following in the column validation on a SharePoint 2013 site

=[Load Date and Time]>=TODAY()

The above works well however I have a flaw in my logic!

I want users to be able to change other fields even if the date in the "Load Date and Time" field is in the past, however if they change the date field itself it must always be today or a future date.

How and where would I enforce this?


1 Answer 1


Use ISBLANK(Created) to check whether the item is new one.

One thread for your reference

Validation formula on new items only


Try below formula which I tested.

=IF(Created=Modified,[Load Date and Time]>=TODAY(),TRUE)
  • Thank you for your reply, I having difficulty with the syntax! =OR(ISBLANK(Created), AND ([Load Date and Time]>=TODAY())) Also tried: =AND(ISBLANK(Created), [Load Date and Time]>=TODAY())
    – Adrian
    Nov 28, 2017 at 13:57
  • Try my updated formula
    – Lee
    Nov 29, 2017 at 6:31
  • Fantastic THANK YOU
    – Adrian
    Nov 29, 2017 at 11:29

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.