TODAY, TIME, and CURRENTDATETIME functions

TODAY retrieves the current system date as set in the operating system. TIME retrieves the current system time as set in the operating system. CURRENTDATETIME retrieves the current date and time in the DATETIME format, which is stored in UTC international time (formerly referenced as GMT or Greenwich Mean Time) and then displayed in local time. If we are using the Windows client, this uses the time in the NAV Client. If the system operates in multiple time zones at one time, search Microsoft Dynamics NAV Help on time zone for several references on how to deal with multiple time zones.

The syntax for each of these is as follows:

DateField := TODAY;
TimeField := TIME;
DateTimeField := CURRENTDATETIME;

These are often used for date- and time-stamping transactions or for filling in default values in fields of the appropriate data type. For data entry purposes, the current system date can be entered by simply typing the letter T or the word TODAY...