Saving DateTime as integer no longer works

PConijn · 2012-09-07

As of today, we have a problem with the datetime as integer. It still fits in a variable, but when we try to use this in an integer table, we get the following error:

Integer Number '1000026000' does not exist.

Up until sept. 6, 2012 it all works, but from sept. 7, onward it errors out with the corresponding integer value.
Has anyone else encountered this and found a solution?

MBerger · 2012-09-07

from the NAV 6.0 R2 Helpfile :

"The Integer virtual table includes integers in the range –1,000,000,000 to 1,000,000,000. The Integer virtual table contains only one field."

and why do you want to add something like that to that table anyway, if i may ask ?

PConijn · 2012-09-07

We're not trying to add to it, but we use the table as a basis for various datetime caluclations, for e.g. rental availability, equipment availability, etc. over time.

PConijn · 2016-06-20

Just came across this and noticed it was open. Our error was due to was a calculation error; it was indeed too large.

Saving DateTime as integer no longer works

Comments

Categories