In a formula-type column, the DAY() function displays the day number of the month from a date-type column.
-
Date function name:
DAY()
Syntax
DAY(date_column)
Function parameter usage in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text, etc.).
- "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 to extract the day of the month. |
Example
DAY($Date)
For a date on the 15th of the month, the column returns 15.
Return Type
The function returns a number (the day of the month, from 1 to 31).
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
DAY() isolates the day of the month to sort, filter, or trigger rules (for example, to identify deadlines falling at the beginning or end of the month).
Best Practice
Do not confuse DAY() (day of the month) with DAY_IN_WEEK() (day of the week).