DAYNO

DAYNO returns the serial date number corresponding to a given date string.

This function is valid in both TM1® rules and TurboIntegrator processes.

Note: DAYNO can return serial dates for date strings starting at January 1, 1960 (dates string 1960-01-01 or 60-01-01). For dates after December 31, 2059, you use a four digit year in the date string. For example, the date string for January 5, 2061 would be 2061-01-05.

Syntax

DAYNO('DateString')

Argument

Description

DateString

A date string in either YY-MM-DD or YYYY-MM-DD format.

Example

DAYNO('98-03-09') returns 13947.