Dates function for IBM Planning Analytics (TM1)

Where can the Dates function be used?

Which TM1 Server version is the Dates function available for?

What is the syntax for Dates?

• Year expressed in YYYY or YY format. ​
• MONTH expressed in MM format. ​
• DAY expressed in DD format. 

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.