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.