Dates function for IBM Planning Analytics (TM1)
Dates returns the date in a string yy-dd-mm or yyyy-dd-mm format.
In this video, the Dates function will be used to display the desired date.
Where can the Dates function be used?
Rules and TurboIntegrator
Which TM1 Server version is the Dates function available for?
Version 11 and 12
What is the syntax for Dates?
Dates(YEAR, MONTH, DAY)
- 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-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.