Rule Functions

TM1 Function for Rules – TIMVL

Available In

Rules and TurboIntegrator


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


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.