• Date and Time Functions
  • Date and Time Functions
  • ADDMONTH function
  • ADDYEAR function
  • DAY function
  • DAYSTR function
  • DMY function
  • DTOS function
  • FMTDATESTR function
  • ITOD function
  • LDATE function
  • MKDATE function
  • MONTH function
  • MONTHSTR function
  • PERSTR function
  • PERTOJ function
  • SDATE function
  • SDATETOJ function
  • SYSDATE function
  • SYSTIME function
  • VERDATE function
  • VERSION function
  • VERTIME function
  • YEAR function

MONTH Function

The MONTH function returns the month as an integer with a value from 1 to 12.

Syntax

MONTH(expression)

Example 1

MONTH(SYSDATE())

If the current system date is June 30, 2007, a value of 6 appears in the cell.

Example 2

MONTH(CLP13)

Where CLP13 represents the year-end date of the client file. If the year-end date is December 31, 2007, a value of 12 appears in the cell.

Related Topics

• Date and Time Functions