TimSt function for IBM Planning Analytics (TM1)

Where can the TimSt function be used?

Rules and TurboIntegrator

Which TM1 Server version is the TimSt function available for?

Version 11 and 12

What is the syntax for TimSt?

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

Relevant Functions

• Date = returns the date in a string yy-dd-mm format.
• Dates = returns the date in a string yy-dd-mm or yyyy-dd-mm format.
• Day = Returns the day from a date in a numeric format.
• DayNo = Returns the serial number from a date in a numeric format.
• Month = Returns the month from a date in a numeric format.
• Now = Returns the current Time in a serial number format.
• Time = Returns the current time from the TM1 server in a string format. 
• TimSt = Returns a formatted date/time in a string format.
• TimVl = Returns a formatted date/time in a string format.
• Today = Returns the current date in a string yy-dd-mm format.
• Year = Returns the year from a date in a numeric format.