I have a field named "Due Date" and I am trying to add validation so users cannot enter a date more than 12 months from today (current date). This is SP2010.

I've tried this formula in the List / Validation Settings.

=[Due Date] < DATE(YEAR(Today()),MONTH(Today())+12,DAY(Today()))

I can't get it to work. I enter a due date which is greater than 12 months from now and it doesn't show me the user message. It allows me to enter the date.

What am I doing wrong?


Try using this:

=[Due Date] < DATE(YEAR(Today())+1,MONTH(Today()),DAY(Today()))


enter image description here

Note: Add this formula inside Column Validation under Column Settings.

  • Thanks your method works as we as my previous formula. I ended up finding that since I was using the formulas in the List Settings / Validation Settings it would not work. When I moved the formula from there to the Column Validation settings they worked.
    – gsr51
    Jun 18 '20 at 18:31
  • Great, glad it worked for you. Please Upvote and accept it as an answer as it helped you. Jun 19 '20 at 2:45
  • And Yes, I tried your formula and it was working for me as well. Jun 19 '20 at 2:48

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.