Skip to content

MONTH

Returns the numeric month for a given date expression.

Reporting Area(s)

General

Required Parameters

  1. Date field (i.e. cobegdate, coenddate, rgaddate)

--OR--Date expression using CTOD() (i.e. CTOD("02/01/2015"))

Optional Parameters

None

Example(s)

MONTH(cobegdate) returns number of the month for the course begin date (i.e. 2 if course begin date is in February)

MONTH(CTOD("02/01/2015") returns 2

Notes

Standard FoxPro Function

CDOW
DOW
CMONTH
YEAR