ADVERTISEMENT

Access: TimeValue Function

---

In Access, the TimeValue function converts a string to a time.

The syntax for the TimeValue function is:

TimeValue ( string_time )

string_time is a string representation of a time. string_time can be a time ranging from 0:00:00 to 23:59:59. string_time can be entered in either 12-hour or 24-hour clock notation.

For example:

TimeValue ("3:12:57 PM")	would return 3:12:57 PM
TimeValue ("15:12:57")	would return 3:12:57 PM

VBA Code

The TimeValue function can be used in VBA code. For example:

Dim LTime As Date

LTime = TimeValue ("18:30:12")

In this example, the variable called LTime would now contain the value of 6:30:12 PM.

SQL/Queries

You can also use the TimeValue function in a query.