Date and Time functions

NAV provides a considerable number of Date and Time functions. We will cover those in the following list. They are are more commonly used, especially in the context of accounting date sensitive activity.

• TODAY, TIME, and CURRENTDATETIME functions
• WORKDATE functions
• DATE2DMY, DATE2DWY, DMY2DATE, DWY2DATE, and CALCDATE functions

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...