Difference between revisions of "Documentation/How Tos/Calc: CONCATENATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
Line 34: | Line 34: | ||
<tt>'''CONCATENATE("Print Date: " ; TEXT(TODAY();"dddd, d mmmm yyyy"))</tt> | <tt>'''CONCATENATE("Print Date: " ; TEXT(TODAY();"dddd, d mmmm yyyy"))</tt> | ||
− | : returns <tt>'''Print Date: Thursday, 1 January | + | : returns <tt>'''Print Date: Thursday, 1 January 2019'''</tt> (assuming today's date was Jan 1, 2019). This example serves to demonstrate that you can combine functions in quite complex ways. This example is made up of the date function <tt>'''TODAY()'''</tt> which returns the current date as a number (NOTE: Jan 1, 2019 is represented as 43466) and the text function <tt>'''TEXT()'''</tt> which allows you to format the numeric representation of the date in a [useful] textual format. |
{{SeeAlso|EN| | {{SeeAlso|EN| |