
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")