In a formula-type column, the TEXT_DAY() function displays the day of the week of a date and returns a text string (the name of the day).
The output type format of the result is configured in the output field options of the formula editor: see Formula column.
Syntax
TEXT_DAY(date_column)
How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.
Parameters
Example
Display the day of the week of a date
If Date = "08/04/2022", the formula returns "Friday" (April 8, 2022, is a Friday). If Date = "22/08/2024", the function returns "Thursday" (August 22, 2024, is a Thursday).
TEXT_DAY($Date)
The day is returned in English (Monday, Tuesday, ...).
Business use case: TEXT_DAY() displays a readable day rather than a number: labeling appointments, spotting deliveries scheduled on a specific day, building a schedule label.
Best practice: to get the day number (useful for calculations or conditions), use DAY_IN_WEEK() rather than TEXT_DAY().
Business use case: TEXT_DAY() displays a readable day rather than a number: labeling appointments, spotting deliveries scheduled on a specific day, building a schedule label.
Best practice: to get the day number (useful for calculations or conditions), use DAY_IN_WEEK() rather than TEXT_DAY().
Go further
FORMAT_DATE
Convert a date to text using the format of your choice.
Or continue with
Formula glossary
All available operators and functions, organized by category.