Sharepoint date and time limit

Question

I created a Date and Time column in the Sharepoint list with the name EventDate. According to Microsoft documentation, the Date and Time column is mapped to the System.DateTime type.

Now I see an error message when I try to insert the following date in this column:

Date: 1/1/1800

Error message: Msgstr "Invalid date / time value. Date / time field contains invalid data. Check value and try again.

I also tried using set DateTime.MinValue and I get the same error message. But if I insert a more recent date like 1/1/1900, for example, it works fine.

Does Sharepoint limit the minimum value of the Date and Time field?

Answer 1

I found out that if you try to insert the value 1/1/1800 into the Sharepoint Date and Time field manually (using the Sharepoint forms), you will get this error:

"You must specify a valid date between 1/1/1900 and 12/31/8900."

Consequently, Sharepoint only accepts values ​​between 1/1/1900 and 12/31/8900.

Answer 2

There is no obvious reason why SharePoint limits the storage of datetime data type, as it is now.

In SQL Server, smalldatetime columns allow you to use a date in the range 1/1/1900 to 6/6/2079, and datetime columns in the range 1/1/1753 - 12/31/9999

So, there is no range from 1/1/1900 - 12/31/8900, and I have no idea why the restriction exists.

To make it even worse: SQL SErver 2008 is of type smalldatetime2 and datetime2 (actually just added 2 to the name: /), which allows any date (1/1/0000 - 12/31/9999), but even SharePoint 2010 on SQL 2008 has the same limit

And Kit: using one line of text is very bad as a wildcard, since there is no way to check the values ​​entered by the user

Answer 3

You can try creating a custom field to hold the datetime value. see http://msdn.microsoft.com/en-us/library/gg132914.aspx