TM1 Function for Rules, TIMVL

TIMVL returns a formatted date/time in a string format. 

Available In

Rules and TurboIntegrator

Definition

TIMVL returns a formatted date/time in a string format. 

Syntax

TIMVL(datetime, type, ExtendedYears

Datetime = a date/time Serial Number  

Type = A character that specifies the type of component to be extracted. The following are valid type arguments: 

Video Demo

In the System info cube, we will use ‘Calendar Month/Year’ elements to format a Serial Number date into numeric values.