The following Cognos TM1 functions deal with dates and times and therefore, I believe that they are important enough to warrant a quick review:
Please note that although all of the mentioned functions are TM1 RULES functions, each can be used within a TI process as well.
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 ...