DATEINWORDS Function: Difference between revisions
From Planfix
(→Import) |
(→Import) |
||
| Line 24: | Line 24: | ||
<pre>twenty-first april twenty twenty-five</pre> | <pre>twenty-first april twenty twenty-five</pre> | ||
==Import== | ==Import== | ||
*This function is available in [[Calculated fields|calculated fields]] and [[Text | *This function is available in [[Calculated fields|calculated fields]] and [[Variables in Text|text containing variables]]. | ||
Revision as of 08:07, 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
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.