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....") |
|||
| (11 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
The DATETOTEXT() function returns a date written out in full words (text format). | The DATETOTEXT() function returns a date written out in full words (text format). | ||
== Format == | == Format == | ||
'''DATEINWORDS('''DATE;LANGUAGE''')''' | '''DATEINWORDS ('''DATE;LANGUAGE''')''' | ||
where: | where: | ||
*DATE — a date or a formula that returns a date as the result. | *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. | *LANGUAGE — an empty string (defaults to the current user's language) or a two-letter language code such as de, en, uk, etc. | ||
== Examples == | == Examples == | ||
<pre>%%% | <pre>%%%DATEINWORDS ("24-03-2025";"en")%%%</pre> | ||
Result: | |||
<pre>twenty-fourth march twenty twenty-five</pre> | |||
If today is april 21: | |||
<pre>{{System.Today.Date in words}}</pre> | |||
Result: | Result: | ||
<pre>twenty- | <pre>twenty-first april twenty twenty-five</pre> | ||
==Import== | |||
*This function is available in [[Calculated fields|calculated fields]] and [[Variables in Text|text containing variables]]. | |||
== Go To == | |||
*[[Standard functions]] | |||
*[[Calculated fields]] | |||
*[[Reports]] | |||
Latest revision as of 12:43, 25 November 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
%%%DATEINWORDS ("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.