The DAY function in TM1 is almost exactly the same as the same function in Excel, in that it returns the day of the month from a date. It is also slightly different to the 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 directly present it with a serial date to get the day of the month. The day of month outcome is a number.
Syntax of the DAY Function in TM1
The syntax of the 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 the function is as follows.
DAY ( '25-08-19' );
This will return the number 19, which could be used in any numeric calculation. Of course, you can use a text variable to populate the function in TM1. In that instance, it would look like this:
sDate = '25-08-19';
DAY ( sDate );
This will result in the same value of 19 as presented above.