Crystal Reports for Eclipse Designer Guide

TimeValue

The CTime and Time functions are equivalent to TimeValue.
Description
Creates a TimeValue value from the information provided.
Overloads
  • TimeValue (number)
  • TimeValue (string)
  • TimeValue (dateTime)
  • TimeValue (HH, MM, SS)
  • Arguments
  • Returns a Time value given a number in units of 24 hours. number can be fractional or negative as well.
  • Returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.
  • DateTime is a DateTime value.
  • Hour is a whole number representing an hour of the day; Min is a whole number representing a minute; Sec is a whole number representing a second.
  • Returns
    Time value.
    Action
    TimeValue (number) returns a Time value given a number in units of 24 hours. The number can be negative or fractional as well.
    TimeValue (string) returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.
    TimeValue (dateTime) returns the time portion of a given DateTime value.
    TimeValue (HH, MM, SS) returns a Time value given numeric arguments of the hour, minute and seconds.
    Examples
    TimeValue (.2)
    TimeValue (1.2)
    Both return the same value 4:48:00 a.m.
    TimeValue (-.2)
    Returns 7:12:00 pm
    TimeValue ("Jan. 6, 1999 2:30pm")
    Returns 2:30:00 pm
    TimeValue (#Feb. 24, 1999 2:40pm#)
    Returns 2:40:00 pm
    TimeValue (18, 30, 30)
    Returns 6:30:30 pm
    Comments
    You can use the IsTime function to check if a string argument can be converted to a Time before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately. See also TimeSerial (hour, minute, second).



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/