0

I have a datepicker. I went into list settings for the start date and set the validation to =Start Date >= today() That works great. Now I want the End Date to be within 2 years of that End Date or before 2021. How would I do that. I tried this =End Date < 2021. That didn't work. It prevented submission of the form. I've been looking but haven't found an answer.

Thanks for your assistance and have a great day!

0

This will only allow people to use a date that is within 364 days of today.

=[End Date]<=TODAY()+364

0

This should do it:

=AND( [Start Date]>=TODAY(), [End Date]<DATE(2021,1,1), [End Date]<TODAY()+(365*2) )

Is dealing with an exact 2 years (leap year, etc.) important?

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.