TM1 Function for Rules, DAYNO
DAYNO returns the serial number from a date in a numeric format.
Where can the DAYNO function be used?
Rules and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the DAYNO function?
DAYNO returns the serial number from a date in a numeric format.
What is the syntax for DAYNO?
DAYNO(date)
Date is a string in format YY-MM-DD.
A demonstration on how to use DAYNO
In the System info cube, we will use ‘Calendar Index’ element to retrieve the serial number from a date.