Rules and TurboIntegrator

TIMST Returns a formatted date/time in a string format.

TIMST(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

Format = A string that formats the result of the function. All the characters in the format argument appear in the result, except for the following characters, which return date/time component values:
– y (two digits of the year e.g. 21)
– Y (four digits of the year e.g. 2021)
– m (two digits of the month e.g. 01 to 12)
– M (first three characters of the month e.g. JAN, FEB)
– d (two digits of the day e.g. 01 to 31)
– D (digit of the day e.g. 1 to 31)
– h (hour in military time e.g. 00 to 23)
– H (standard hour e.g. 1 to 12)
– i (minute e.g. 00 to 59)
– s (second e.g. 00 to 59)
– p (a.m. or p.m.)

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 ‘Server Time’ element to format a Serial Number date and time.