Rule Functions

TM1 Function for Rules – TIMVL

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.