DAY TM1 Function: How to Use, Syntax and Example
The DAY function in TM1 is almost exactly the same as the DAY function in Excel, in that it returns the day of the month from a date. It is also slightly different to DAY in Excel in that the source for the function is a string based date, either in the form YY-MM-DD or YYYY-MM-DD. Therefore you cannot present it with a serial date to get the day of the month. The day of month outcome is a number.
Syntax of DAY
The syntax of the DAY function in TM1 is dead simple. It is just:
DAY ( DateString );
where:
DateString is either in the form YY-MM-DD or YYYY-MM-DD
Example
An example of DAY is as follows.
DAY ( '21-08-19' );
This will return the number 19.