TM1 Function for Rules, DATES

DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format.

Available In

Rules and TurboIntegrator

Definition

DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format.

Syntax

DATES(YEAR, MONTH, DAY) 

Year expressed in YYYY or YY format. 

MONTH expressed in MM format. 

DAY expressed in DD format. 

Video Demo

In the System info cube, we will use ‘Calendar Index’ element to display the desired date.