DATEINWORDS Function

From Planfix
Jump to: navigation, search

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

Format

DATEINWORDS(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


Go To