LEAPYEARS()

From Lianjapedia
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, 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