-
Book Overview & Buying
-
Table Of Contents
IBM Cognos TM1 Developer's Certification guide
By :
The following Cognos TM1 functions deal with dates and times and therefore, I believe that they are important enough to warrant a quick review:
DATE
DATES
DAY
DAYNO
MONTH
NOW
TIME
TIMST
TMIVL
TODAY
YEAR
Please note that although all of the mentioned functions are TM1 RULES functions, each can be used within a TI process as well.
The DATE function returns a date string like YY-MM-DD for a given serial number. Good to know because the function NOW will return us a serial number!
Foo=DATE(NOW, 1); # --- will return a string of 'YYYY-MM-DD"
DATES is a little more practical (in my opinion). It takes a numeric value for a given year, month, and day and returns a string in a similar format:
Foo=DATES(2012,12,2); # --- will return a string of "YYYY-MM-DD"
DAY returns a numeric value for the day in a given date string:
Foo=DAY('02-05-25');
# --- will return 25
DAYNO is reverse of DAY, the DAYNO function returns the serial date number...
Change the font size
Change margin width
Change background colour