Why can I store a date < 1.1.1900 in a date local variable?

Why can I store a date < 1.1.1900 in a date local variable?

  

This site (link: https://success.outsystems.com/Documentation/10/Reference/Data/Data_Types/Available_Data_Types) states that the minimum value for a date would be 1.1.1900 . Why can I still store a value below that limit ( e.g. 5.3.1820)? I am working on a .NET platform.

Solution

Hi,

I think the OutSysterms documentation is incorrrect.

#1900-01-10# is used as a null date (no date), as far as came across the minimum date is #1753-01-01# and the maximum data is #9999-12-31# in OutSystems. 

Think OutSystems should update their documentation.

Regards,

Daniel


Solution

Thanks for your reply, I wrote a message to the support with the request to update the documentation.

Daniel. Thanks for you information, I didn't know it


But Daniel, think a little about your information what happen when I add a day to #1899-12-31# ?

Hi Alberto,

If you add 1 to #1899-12-31# it returns #1900-01-01#, and if you check this being NullDate() it will return true.

If you add 2 to #1899-12-31# it returns #1900-01-02#, so I think, calculation wise it is safe.

Even if you subtract 1 from #1753-01-01# it returns #1752-12-31# even though you can not select that date as a valid date in the calendar input widget.

Remains a peculiar situation that OutSystems defines a true valid date as #1900-01-01# as null date. 

For anyone wondering why the true minimum date is in the year 1753, read this https://en.wikipedia.org/wiki/Gregorian_calendar

Regards,

Daniel

Hello Daniel 


Do you mean that I can store the value of 1753-01-01 in an parameter|variable ?


Regards

Daniël Kuhlmann wrote:

Hi Alberto,

If you add 1 to #1899-12-31# it returns #1900-01-01#, and if you check this being NullDate() it will return true.

If you add 2 to #1899-12-31# it returns #1900-01-02#, so I think, calculation wise it is safe.

Even if you subtract 1 from #1753-01-01# it returns #1752-12-31# even though you can not select that date as a valid date in the calendar input widget.

Remains a peculiar situation that OutSystems defines a true valid date as #1900-01-01# as null date. 

For anyone wondering why the true minimum date is in the year 1753, read this https://en.wikipedia.org/wiki/Gregorian_calendar

Regards,

Daniel

Agreed that #1900-01-01# is a valid date but now if they changed it, it will create mess for so many applications.