This function says that it can take a string in any valid date and/or time format. It further says that if the year portion of the input string is ommitted, that the current year is used. But what if the date is omitted as well, e.g, someone passes in a pure time string like "10:34" Do we assume the current date Or assume January 1st of the current year

Resolve the ambiguity in the definition when a string with time format is passed in.

DATEVALUE Part 4, Section 3.17.7.76

te

Proposed Disposition of DIS 29500 Comment GR-0111 (Modified: 2007-11-15) Agreed; The DATEVALUE function truncates times, and the following change will be made to Part 4, 3.17.7.76, page 2,603: Description: Computes the serial value of the date and/or time represented by the string date-time- string, taking into account the current date base value. Arguments: Name Type Description date-time-string text The date and/or time whose serial value is to be computed. date-time-string can have any valid date and/or time format. If the year portion of date-time-string is omitted, the current year is used. Any time information in date-time-string shall be ignored. When date-time- string contains both a date and time part, times in date-time-string are truncated. Time only values for date-time-string are special cased to return 0 so that ­ when used in date addition and subtraction ­ time only strings are ignored. Return Type and Value: number ­ The serial value of the date and/or time represented by the string date-time-string. However, if date-time-string is out of range for the current date base value, #VALUE! is returned. date-time-string does not represent a date, #VALUE! is returned. date-time-string contains only a time, 0 is returned so that when used in date addition and subtraction time-only strings are ignored. Similar Comments: CA-0054 , CL-0187 , CO-0179 , FR-0511 , GB-0392 , US-0191