Tag Archives: Date

How to Dynamically Assign Data based on Selection in a Planning Model

How to create a planning model where users can enter and select variables in one location and TM1 then assigns the data dynamically to all required dimensions.

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

MONTH Function in TM1: Syntax and Use

The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

Date Function in TM1: Syntax and Use

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.