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.

| improve this answer | |
  • 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 at 18:31
  • Great, glad it worked for you. Please Upvote and accept it as an answer as it helped you. – Ganesh Sanap Jun 19 at 2:45
  • And Yes, I tried your formula and it was working for me as well. – Ganesh Sanap Jun 19 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.