AgileApps Support Wiki Pre Release

YEAR

From AgileApps Support Wiki
Revision as of 18:42, 4 November 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The YEAR function reads a date and returns the year value.

Syntax
YEAR(dString)
Return
Number in the format: yyyy
Range 1900 - 9999
Examples
YEAR('02/14/2010') = 2010
YEAR('02/14/2010 12:15 pm') = 2010