DataFunctions.ValidateDateTime Method

The ValidateDateTime method checks whether a string contains a valid date and/or time, and optionally checks against a specified range. If the value is a valid date or time and falls within the given range if specified, ValidateDateTime returns True; otherwise, False.

Syntax

DataFunctions.ValidateDateTime(DateTime, LowDateTime, HighDateTime)

Parameters

DateTime

The value to validate. This value can be a date, a time, or both.

LowDateTime

Optional. This value designates the low end of the range. The default value for this parameter is Null, which means that LowDateTime is ignored in the range validation.

HighDateTime

Optional. This value designates the high end of the range. The default value for this parameter is Null, which means that HighDateTime is ignored in the range validation.