Date and Time functions

NAV provides a considerable number of Date and Time functions. We will cover a number of these functions that are more commonly used, especially in the context of accounting date sensitive activity. These are as follows:

• TODAY, TIME, and CURRENTDATETIME

• WORKDATE

• DATE2DMY, DATE2DWY, DMY2DATE, DWY2DATE and CALCDATE

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, these use the time on the NAV Client. If your system operates in multiple time zones at one time, you should enter a search value of time zone in Microsoft Dynamics NAV Help to review the several references on how to deal with multiple time zones...