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
, andCURRENTDATETIME
functionsWORKDATE
functionsDATE2DMY
,DATE2DWY
,DMY2DATE
,DWY2DATE
, andCALCDATE
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...