DATEINWORDS Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=DATEINWORDS Function |titlemode=append |keywords=Planfix, Function, DATEINWORDS, Reports |description=DATEINWORDS Function }} 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....") |
|||
| Line 16: | Line 16: | ||
Result: | Result: | ||
<pre>twenty-fourth march twenty twenty-five<pre> | <pre> twenty-fourth march twenty twenty-five <pre> | ||
Revision as of 07:52, 24 March 2025
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