• 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