SqlDateTime overflow error

SqlDateTime overflow error

  

I receive the following error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

I'm working on a family tree database, but now I can't fill in a date before 1753. Can somebody help me with this?


Solution

It seems to be a limitation of the OutSystems platform that uses both Date and DateTime as datetime sql server data type, and thus, the limitation of 1753.

The only "easy" way I can think of to workaround this issue is to store your dates in a different forma (like text, for example), or like separate entities (year, month and day), that will help you with ordering and this kind of things.

You can see a discussion on the subject (but more focused on NULL), here.

Solution