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.



text is a valid date expression that must be entered with double quotation marks.

  • 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.


=DATEVALUE("7/20/54") yields 19925.