TimVl function for IBM Planning Analytics (TM1)

Where can the Date function be used?

Which TM1 Server version is the Date function available for?

What is the syntax for Date?

• Datetime = a date/time serial number
• 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 em

Relevant Functions

• Date = returns the date in a string yy-mm-dd format.
• Dates = returns the date in a string yy-mm-dd or yyyy-mm-dd 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-mm-dd format.
• Year = Returns the year from a date in a numeric format.