TimeValue Function

   
TimeValue Function

Class

Microsoft.VisualBasic.DateAndTime

Syntax

 TimeValue(   stringtime   ) 
stringtime (required; String)

Any valid string representation of a time

Return Value

A Date containing the time specified by the string argument, with the date set to January 1 of the year 1

Description

Converts a string representation of a time to a Date data type

Rules at a Glance

  • If stringtime is invalid, a runtime error is generated.

  • If stringtime is Nothing , TimeValue generates an error.

  • stringtime can be in any time format recognized by the IsDate function. Both 12- and 24- hour clock formats are valid.

  • The Date value returned by time is formatted based on the system's regional settings.

Programming Tips and Gotchas

  • A time literal can also be assigned to a Date variable by surrounding the date with hash characters ( # ), as the following snippet demonstrates :

     Dim dMyTime As Date dMyTime = #12:30:00 AM# 
  • The CDate function can also cast a time expression contained within a string as a Date variable, with the additional advantage of being internationally aware.

  • The string returned by the TimeString property also includes an invalid date, 01/01/0001. It can be eliminated with the Format or FormatDateTime function as follows :

     Format(TimeOfDay(  ), "Long Time") FormatDateTime(TimeOfDay(  ), DateFormat.LongTime) 

VB/NET/VB 6 Differences

In VB 6, TimeValue returns the time only. In VB.NET, the function also returns an invalid date, 01/01/0001, along with the time.

See Also

TimeOfDay Property, TimeSerial Function, TimeString Property

   


VB.Net Language in a Nutshell
VB.NET Language in a Nutshell
ISBN: B00006L54Q
EAN: N/A
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net