Datetime into Navision

sabzam

Hi Everybody,

I've got an ambigous problem in Navision. I have got a field datetime. Whenever I am inserting the datetime as 010101 12:44 it is inserting into the db itself as 010101 10:44, and the other way round....if i insert dirently into the db 010101 12:44 it is being viewed into navision as 010101 14:44.

For some reason there's a descrepancy of 2 hours between the actual sql data and what is seen into navision

kriki

Probably because you have some difference in timezone.

The datetime-fields is always saved as UMT.
When showing it, it is converted to the hour on the PC, using the timezone.