Customer.[Last Date Modified] has no hours and minutes

Business Central/NAV Developers Forum
1

Customer.[Last Date Modified] column records don’t save hours, minutes and milliseconds . Example: “2010-12-12 00:00:00.000”.

How do we enable Last Date Modified in NAV to be stored, as full timestamp?

We need to

2

You can create new field with Datatype Datetime and write code in OnModify() trigger of table as

“Last Date Time Modified” := CURRENTDATETIME;

3

Hi Mohana,

Thanks for your reply, but we can not change client NAV dabatase structure at all.

We are connecting to NAV via web service, and need to retrieve Customer “Last Date Modified” as a full timestamp. How can we do that?

Regards,

Antanas

4

you can’t without chnaging the database field type as explained above.