TM1 Function for Rules, MONTH

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

Available In

Rules and TurboIntegrator

Definition

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

Syntax

YEAR(date) 

Date is a string in format YY-MM-DD. 

Video Demo

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