TM1 Function for Rules, TIMVL

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

Where can the TIMVL function be used?

Rules and TurboIntegrator

What is the TIMVL function?

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

What is the syntax for TIMVL?

TIMVL(Datetime, Format, ExtendedYears) 

Datetime = a date/time serial number
– 0 = 01 Jan 1960
– 2936549 = 31 Dec 9999
* Note the ExtendedYears field if you want to return a date past 31 Dec 2059
* Negative numbers will return prior dates from 01 Jan 1960

Format = A character that specifies the type of component to be extracted. The following are valid type arguments:
– Y (four digits of the year e.g. 2021)
– M (digit of the month e.g. 1 to 21)
– D (digit of the day e.g. 1 to 31)
– H (hour in military time e.g. 00 to 23)
– I (minute e.g. 00 to 59)
– S (second e.g. 00 to 59)

ExtendedYears = OPTIONAL Boolean parameter on the date range recognised (if this field is empty, 0 is used)
– 0 = returns a date falling between 01 Jan 1960 to 31 Dec 2059 
– 1 = returns a date falling between 01 Jan 1960 to 31 Dec 9999

A demonstration on how to use TIMVL

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