Does this code work or not?

It does compile without errors. But does it also run without errors?
datshipmentdate := 01072012D;
intDateDec := 9999;
intDateDec := (CREATEDATETIME(”datShipmentdate”, 0T) - CREATEDATETIME(010180D, 0T)) / 86400000;
I’ll give the SQL answer (even if SQL has nothing to do with it): it depends.
It works on 4.0SP3 Build 25638,5.0SP1 Build 26084.
It gives an error on 5.0SP1 Build 30488,NAV2009 build 27808,NAV2009SP1 […]

Create a new blog and join in the fun!