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

Which TM1 Server version is this function available for?

Version 11 and 12

What is the DATE function?

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

What is the syntax for DATE?

DATE(SerialNumber, u003cReturnFourDigitsYearu003e) ​
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.