DateValue Function

Syntax:

DateValue(Date$)

Group:

Time/Date

Description: Returns the day part of the date encoded as a string.

Parameters:

Parameter

Description

Date$

Convert this string value to the day part of date it represents.

Example:

Sub Main
  Debug.Print DateValue("1/1/2000 12:00:01 AM") '1/1/2000
End
Sub

See Also:

DateSerial, TimeSerial, TimeValue.