Cognos TM1 Date and Time Rules Functions

Cognos TM1 Date and Time Rules Functions:

• DATE
• DATES
• DAY
• DAYNO
• MONTH
• NOW
• TIME
• TIMST
• TIMVL
• TODAY
• YEAR

DATE:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes. DATE returns the date string in 'yy-mm-dd' or 'yyyy-mm-dd' format for a given serial number.
Syntax:
DATE(SerialNumber, ReturnFourDigitYear)


Arguments:

Argument	Description
SerialNumber	A date expressed in serial format.
ReturnFourDigitYear	An optional Boolean argument that determines whether the DATE function returns a string using two- or four-digit notation for the year. If ReturnFourDigitYear is true, the function returns date falling within the range of Jan. 1, 1960 and Dec. 31, 9999, using four-digit notation for the year. Serial date 0 corresponds to Jan. 1, 1960 and serial date 2936549 corresponds to Dec. 31, 9999. If ReturnFourDigitYear is false, or if this optional argument is omitted from the DATE function, the function returns a date falling within the range Jan. 1, 1960 and Dec. 31, 2059, using two-digit notation for the year. Serial date 0 corresponds to Jan 1, 1960 and serial date 36524 corresponds to Dec. 31, 2059. If ReturnFourDigitYear is false or is omitted and you specify a serial date greater than 36524, the serial date used by the function is determined by the formula n - 36525. For example, if you specify a serial date of 36530, then 36530 - 36525 = 5. In this case, DATE uses 5 as the serial date and returns the date Jan. 6, 1960.

Example:
DATE(13947) returns '98-03-09'.
DATE(13947, 1) returns '1998-03-09'.

DATES:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes. DATES returns a date string, in the form 'yy-mm-dd' or 'yyyy-mm-dd', corresponding to a given year, month, and day.
Syntax:
DATES(year, month, day)
Example:
DATES(98, 2, 10) returns '98-02-10'.
DATES(1998, 2, 10) returns '1998-02-10'.

DAY:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
DAY returns a numeric value for the day in a given date string.
Syntax:
DAY(DateString)
Example: DAY('02-05-25') returns 25.

DAYNO:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes. DAYNO returns the serial date number corresponding to a given date string.
Note: DAYNO can return serial dates only for date strings between 1960-01-01 and 2059-12-31.
Syntax:
DAYNO('DateString')
Example:
DAYNO('98-03-09') returns 13947.

MONTH:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
MONTH returns a numeric value for the month in a given date string.
Syntax:
MONTH(date)
Example:
MONTH('02-05-25') returns 5.

NOW:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes. NOW returns the current date/time value in serial number format.
Syntax:
NOW

Arguments:
None.
Example:
NOW returns the current date/time value in serial number format.

TIME:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
TIME returns a string, in HH:MM format, representing the system time on the TM1 server.
Syntax:
TIME

Arguments:
None.

Example:
Given a system time of 9:33 AM, TIME returns the string '09:33'.
Given a system time of 9:33 PM, TIME returns the string '21:33'.

TIMST:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
TIMST returns a formatted date/time string.
Syntax:
TIMST(datetime, format, ExtendedYears)

Example:
TIMST(366.0000, '\M \D, \Y') returns 'JAN 1, 1961'.
TIMST(366.5000, '\H\p \imin\ssec') returns '12p.m. 00min00sec'.
TIMST(366.1000, 'On \M \D, \Y at \H\p \imin\ssec') returns 'On JAN 1, 1961 at 2a.m. 24min00sec'.
TIMST(11111.1100, 'On \M \D, \Y at \H\p \imin\ssec') returns 'On JUN 3,1990 at 2a.m. 38min24sec'.

TIMVL:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
TIMVL returns the numeric value of a component (year, month, etc.) of a date/time value.
Syntax:
TIMVL(datetime, type, ExtendedYears)

Example:
TIMVL(11111.1100, 'Y') returns 1990.
TIMVL(11111.1100, 'H') returns 2.

TODAY:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
TODAY returns the current date in yy-mm-dd format.
Syntax:
TODAY(ReturnFourDigitYear)

YEAR:
This is a TM1 rules function, valid in both TM1 rules and TurboIntegrator processes.
YEAR returns a numeric value for the year in a given date string.
Syntax:
YEAR(date)

Example:
YEAR('02-05-25') returns 2.