Difference between revisions of "Documentation/How Tos/Calc: DATEVALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
Line 8: | Line 8: | ||
<tt>'''DATEVALUE(datetext)'''</tt> | <tt>'''DATEVALUE(datetext)'''</tt> | ||
: <tt>'''datetext'''</tt> is a date, expressed as text. | : <tt>'''datetext'''</tt> is a date, expressed as text. | ||
+ | |||
+ | : <tt>'''DATEVALUE'''</tt> returns the date-time serial number, which may be formatted to read as a date. | ||
Line 25: | Line 27: | ||
=== Issues: === | === Issues: === | ||
− | The forthcoming ODFF standard requires DATEVALUE to return the date-time serial number as a date, so Calc should format the result as a date. However currently Calc seems to return the date-time serial number as a number, requiring the user to format the result manually. | + | The forthcoming ODFF standard requires <tt>'''DATEVALUE'''</tt> to return the date-time serial number as a date, so Calc should automatically format the result as a date. However currently Calc seems to return the date-time serial number as a number, requiring the user to format the result manually. See [http://www.openoffice.org/issues/show_bug.cgi?id=84903 Issue 84903] |
Revision as of 19:18, 28 December 2007
DATEVALUE
returns the date-time serial number, from a date as text.
Syntax:
DATEVALUE(datetext)
- datetext is a date, expressed as text.
- DATEVALUE returns the date-time serial number, which may be formatted to read as a date.
Example:
DATEVALUE("2007-11-23")
- returns 39409, the date-time serial number for 23Nov2007 (assuming the default date-time starting date)
See also:
Issues:
The forthcoming ODFF standard requires DATEVALUE to return the date-time serial number as a date, so Calc should automatically format the result as a date. However currently Calc seems to return the date-time serial number as a number, requiring the user to format the result manually. See Issue 84903