In a formula-type column, the MONTH() function displays the month number from a date-type column.
-
Date function name:
MONTH()
Syntax
MONTH(date_column)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date-type column from which you want the month number. |
Example
MONTH($Date)
For a date in April, the column returns 4.
Return type
The function returns a number (the month, from 1 to 12).
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business use case
MONTH() groups data by month: filter records for a given month, feed a monthly pivot table.
Best practice
Combine MONTH() with YEAR() (or use YEAR_MONTH()) to distinguish the same month across multiple years.