DATEINWORDS Function

The DATETOTEXT() function returns a date written out in full words (text format).

Format

DATETOTEXT(DATE;LANGUAGE)

where:

• DATE — a date or a formula that returns a date as the result.
• LANGUAGE — an empty string (defaults to the current user's language) or a two-letter language code such as de, en, uk, etc.

Examples

%%%DATETOTEXT("24-03-2025";"en")%%%

Result:

twenty-fourth march twenty twenty-five

If today is april 21:

{{System.Today.Date in words}}

Result:

twenty-first april twenty twenty-five

Import

• This function is available in calculated fields and text containing variables.

Go To

• Standard functions
• Calculated fields
• Reports