I ran across a situation today where a client wanted to store and manage dates that were earlier then 1900. The out of box SharePoint Date/Time metadata column doesn’t allow this. Without custom coding, your only option is to store this data as a single line of text. As you could imagine, there is problems with this; including no formatting, i.e. anyone could enter anything they wish!
Fortunately, this particular customer had purchased the Bamboo Solutions Enterprise product which included their Bamboo Validator Column. This column allows you to select various data types and include a validation string. I still found I had to select the Single Line of Text data type but was able to add the following validator: “([1-9]|0[1-9]|1[012])[- /.]([1-9]|0[1-9]|[12][0-9]|3[01])[- /.][0-9]{4}$”. This validator allows for any valid date.
Bamboo to the rescue!
