Strange I found just, that it is not possible to enter a date <= 01.01.1970 (german).
If a enter a value, let's say "-9000", then it is possible to enter a date before 1970.
If I enter the date directly 0101970 I receive an "invalid date" error ?

Is that a normal behaviour?

Spartacus

My guess is that if you enter a date before the minimum date (i.e. 01/Jan/1970 00:00) then the 4GL Engine will check the input and shows the input error Invalid Date.
If you assign a negative value to an utc variable this check is not executed, so there is no error message given. However, if you store the value in a table I expect an error to pop up. Besides that, utc conversion function will return -1 which indicates an error.

For the first sorry, I made a mistake. It is -9000 is not before 1.1.1970 !!!!!!

So I found that there is now way to enter a date before 01.01.1970? Am I right?


Spartacus