In sharepoint, the date picker function has a limit such that if you pick a date beyond what the system gives, it produces the following error:

"You must specify a valid date within the range of 01.01.1900 and 31.12.8900

I have items with no expiry dates. How do I customize the date picker validation in sharepoint such that it has no date limit but it also cannot be left blank?

I'm not sure if I should be using jquery. I came across this post which uses a formula to edit the validation: Validating dates in SharePoint so they cannot choose a date before today's date, how would I write that formula? . If I'm supposed to use this method instead, what kind of formula should I use?

Fyi, my default datepicker in sharepoint contains a ms-formbody, which contains a formfield data-binded to the datepicker itself.

1 Answer 1


Go through this link.... http://techtrainingnotes.blogspot.fr/2010/08/sharepoint-creating-calculated-column.html

=OR([Effective Date]=DATEVALUE("9/21/2015"),[Effective Date]=DATEVALUE("10/5/2015"), 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.