Hi, I’m a SQL Server guy, so forgive the simplicity of this question. Are dates stored as true date values in Navision Server 2.60, i.e. as a numeric offset from January 01, 0000? Are they therefore stored in one way and one way only, i.e. regardless of the short date format on the server differing from the client, etc., is the actual storage constant? Waynewil
Yes its a fixed offset, in steps of 2. The first step represents the date itself, and the second is the closing date of that date. So value 0 is Undefined, 1 is ‘1 Jan 0000’, and 2 is ‘C 1 Jan 0000’.