In a formula-type column, the TEXT_DAY() function displays the day of the week of a date as text.
-
Text function name:
TEXT_DAY()
Syntax
TEXT_DAY(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 for which you want the day of the week. |
Example
TEXT_DAY($Date)
If Date = "08/04/2022", then TEXT_DAY($Date) returns Friday (April 8, 2022, is a Friday). If Date = "22/08/2022", the function returns Thursday (August 22, 2022, is a Thursday).
Notes
- The day is returned in English (Monday, Tuesday, ...).
Return Type
The function returns a text string (the name of the day).
The output format type 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
TEXT_DAY() displays a readable day instead of a number: labeling appointments, identifying deliveries scheduled for a specific day, creating a schedule label.
Best Practice
To get the day number (useful for calculations or conditions), use DAY_IN_WEEK() instead of TEXT_DAY().