TM1 Function for Rules, DATE

​DATE returns the date in a string yy-dd-mm format.

Where can the DATE function be used?

Rules and TurboIntegrator

What is the DATE function?

​DATE returns the date in a string yy-dd-mm format.

What is the syntax for DATE?

DATE(SerialNumber, <ReturnFourDigitsYear>) ​
SerialNumber is a date expressed in a serial format number. ​
An optional boolean argument to display the Year in 4 digits

A demonstration on how to use DATE

In the System info cube, we will use ‘Server Time’ element to create a rule to display the date.