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

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.