Unix Datetime UTC

Here’s a little trick to generate a Unix Datetime in UTC. PROCEDURE DT2UnixDTUTC@81237(DtIn@81200 : DateTime) : BigInteger; VAR DtOffset@81203 : DotNet “‘mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089’.System.DateTimeOffset”; DtUtc@81206 : DateTime; Duration@81208 : Duration; TempDate@81209 : Date; TempTime@81210 : Time; BEGIN EVALUATE(TempDate, COPYSTR(FORMAT(DtIn, 0, 9), 1, 10)); EVALUATE(TempTime, COPYSTR(FORMAT(DtIn, 0, 9), 12, 8)); DtUtc := CREATEDATETIME(TempDate, TempTime); Duration […]

Json, REST and Zendesk

Many of us have been using XML and SOAP for a long time now. This time my task was to create tickets in Zendesk based on events in NAV. I soon discovered that Zendesk uses REST web services and that it talks Json…. 😯 I soon found Gunnar Gestssons blog post on “JSON meets NAV“. […]


One very cool feature in NAV2016 is the table type “ExternalSQL”. In older versions you had to use a view in SQL for each table and set the property LinkedObject. Now you don’t have to do that any more. Let’s take a look at it: Here you can see how you can use TableType, ExternalName […]