<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

TM1 Function for Rules, MONTH

​MONTH returns the month from a date in a numeric format.

Where can the MONTH function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the MONTH function?

​MONTH returns the month from a date in a numeric format. 

What is the syntax for MONTH?

MONTH(date) ​
Date is a string in format YY-MM-DD. 

A demonstration on how to use MONTH

In the System info cube, we will use ‘Calendar Month’ element to retrieve the month from a date.