LEAPYEARS()

From Recital Documentation Wiki
Revision as of 13:49, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return number of leap years between 01/01/0001 and the specified date


Syntax

LEAPYEARS(<expD> | <expT> | <expN>)


See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), SYS(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

The LEAPYEARS() function is used to return number of leap years between 01/01/0001 and the specified date. The date can be specified as a date expression (<expD>), a datetime expression (<expT>) or as a numeric value indicating a Julian date (<expN>).


Example

? leapyears(date())
       487
? leapyears(datetime())
       487
? leapyears(val(sys(1)))
       487


Products

Recital Server, Recital