TM1 Function for Rules, DATES
DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format.
Where can the DATES function be used?
Rules and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the DATES function?
DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format.
What is the syntax for DATES?
DATES(YEAR, MONTH, DAY)
Year expressed in YYYY or YY format.
MONTH expressed in MM format.
DAY expressed in DD format.
A demonstration on how to use DATES
In the System info cube, we will use ‘Calendar Index’ element to display the desired date.