NAV 6.0 - Customer LAST DATE MODIFIED

I_Dunno
I_Dunno Member Posts: 3
edited 2010-01-13 in NAV/Navision Classic Client
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!

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Last Date Modified is type DATE not DATETIME
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • I_Dunno
    I_Dunno Member Posts: 3
    Thanks for the reply. Is there no other field then that stores when (date, time) and by who the record was last updated?
  • ara3n
    ara3n Member Posts: 9,258
    If you use ChangeLog and setup to monitor the customer table, then you will find records on when (datetime) and who modified what field.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,127
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories