AX / D365FO – Electronic Reporting Format a Date

In Electronic Reporting you can easily format a Date or DateTime using DATEFORMAT() or DATETIMEFORMAT()

Here is an example of how to use it

DATEFORMAT needs 2 input parameters :

• Date (or dateTime in case of DATETIMEFORMAT)
• format (which is the output conversion format)
  

Code below shows how to convert current date in yyyyMMdd format

DATEFORMAT(TODAY(), "yyyyMMdd"))

Code below shows how to convert current dateTime in yyyyMMdd_hhmmss format

DATETIMEFORMAT(NOW(), "yyyyMMdd_hhmmss")