Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Fill a field with date...

Fill a field with datetime

(0) Share

Report

Posted on by Community Member

Hi,

I'm new to Nav. I need to fill datetime automatically representing the time when a new record is created in table "trans. Sales entry". I have added to this table a new filled "replicationTime". I know i have to use the on insert trigger. But i need the coding for that. Can anyone help !

Thank you,

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Aleksandar Totovic 16,765 on at

Like (0)

Report

RE: Fill a field with datetime

You need to add on InitRecord() part of code, depends what you want:

1) Date and Time -> "ReplicationTime" := CURRENTDATETIME;

2) Only Time -> "ReplicationTime" := TIME;

3) Only Date -> "ReplicationTime" := TODAY;