• Date and Time Functions
  • ADDMONTH Function
  • ADDYEAR Function
  • Date and Time Functions
  • 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