TIMVL returns a formatted date/time in a string format.
Rules and TurboIntegrator
TIMVL returns a formatted date/time in a string format.
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 12)
– 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
In the System info cube, we will use ‘Calendar Month/Year’ elements to format a Serial Number date into numeric values.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book