CVDate

Function that converts an expression into a date value

Syntax
      CVDate (expression)

The expression must be a valid date. CVDate accepts either the date or the time, or both. Possible values range from January 1, 100 to December 31, 9999.

CVDate() has identical syntax to CDate(), CVDate() returns a Variant with the subtype of Date, CDate() returns an actual Date type.

CVDate is useful in calculated date fields that may contain Null values.

Example

Dim dtmRetirement as Date

dtmRetirement = CVDate("Aug 6, 2083")
dtmRetirement = CVDate(Me!txtDate)

“The hours of folly are measured by the clock, but of wisdom no clock can measure” ~ William Blake

Related:

CBool - Convert to boolean
CInt - Convert to Integer (number)
DateSerial - Return a date given a year, month, and day.
Nz - Detect a NULL value.


© Copyright SS64.com 1999-2014
Some rights reserved