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?