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 omitted, 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" Is it to be assumed as current date Or assume January 1st of the current year

Describe the boundary conditions for when only the time format is specified.

DATEVALUE Part 4, Section 03.17.07.76

TE

Proposed Disposition of DIS 29500 Comment CA-0054 (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: CL-0187 , CO-0179 , FR-0511 , GB-0392 , GR-0111 , US-0191