AgileApps Support Wiki Pre Release

MONTH

From AgileApps Support Wiki
Revision as of 21:37, 25 August 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The MONTH function reads a date and returns the month value.

Syntax
MONTH('dString')

Date, month, and year are required; hour and minute are optional.

Return
Number in the format: mm
Range 1 (January) - 12 (December)
Example
MONTH('06/13/2006') = 06