DATEVALUE function
DATEVALUE returns the internal date number for text in double quotation marks when the text format indicates a date. The internal number is returned as a natural number, resulting from the date system used by HCL Connections™ Docs to calculate dates.
Syntax
DATEVALUE("text")
text is a valid date expression that must be entered with double quotation marks.
Note:
- The supported date range is from Dec. 30, 1899 to Dec. 31, 9999.
- The short date, which is one- or two-digit year, is interpreted as 20xx.
Example
=DATEVALUE("7/20/54") yields 19925.