Time Format <Second dec> always zero in Microsoft Dynamics Navision 2009

1.5k Views Asked by At

In a table in Dynamics Navision 2009 we use a field named [Last Time Modified]. Data type is Time (in the database it is a DateTime). It contains values with fractions of seconds (like 13:14:15.678).

In NAV / Connectivity Studio / Documents / Export, the fractions are not exported by default to the XML. So I created my own format (see also: https://learn.microsoft.com/en-us/dynamics-nav/format-property):

<Hours24,2>:<Minutes,2>:<Seconds,2><Second dec,4>

which results in the XML as:

13:14:15,000

The fraction part is always 0. What I need is:

13:14:15,678

Any solutions?

1

There are 1 best solutions below

1
On

Did you try <Hours24>:<Minutes,2>:<Seconds,2>,<Second dec.>? I took standard one and changed to colon and comma in places where needed.