NAV 6.0 - Customer LAST DATE MODIFIED

I_Dunno

Hi All,

I'm using NAV v6.0 (SQL). I looking at building integrations between NAV and MS CRM but was just doing some investigations into the record creation/modified dates. My question is....

Against the CUSTOMER record I can see an attribute for 'Last Date Modified'. This look to be in the normal date and time stamp format (i.e. 2010-01-11 00:00:00.000). From looking at the table this field correctly logs the date but no time is being logged against the record.

Examples....

2010-01-10 00:00:00.000
2010-01-09 00:00:00.000
2010-01-05 00:00:00.000

Why is the database not recording the time in the alongside the date - is there a setting within the NAV app that has to be enabled?

Thanks in advanced!

Savatage

Last Date Modified is type DATE not DATETIME

I_Dunno

Thanks for the reply. Is there no other field then that stores when (date, time) and by who the record was last updated?

ara3n

If you use ChangeLog and setup to monitor the customer table, then you will find records on when (datetime) and who modified what field.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]