Function Description
| Category | Description |
|---|---|
| Syntax | MONTH(date) |
| Function | Returns the month value from a specified date. |
| Parameter | date: a specified date value Only date or datetime values are supported. |
| Number of Parameters | 1 |
| Parameter Type | Date or datetime |
| Return Value Type | Number from 1 to 12 |
Examples
| Formula | Result |
|---|---|
MONTH(DATE(2000,1,1)) | 1 |
MONTH(TODATE("1999-02-03")) | 2 |
More Examples
For example, you can use MONTH to get the month value from Start Time.
