1

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?

thanks

3

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

One thread for your reference

Validation formula on new items only

Update:

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 '17 at 13:57
  • Try my updated formula – Lee_MSFT Nov 29 '17 at 6:31
  • Fantastic THANK YOU – Adrian Nov 29 '17 at 11:29

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.