Description:
Returns a date without time.
Syntax:
Date DateValue(Date date)
Parameters:
date | (Date) Date from 1.1.100 to 31.12.9999 |
---|
Note:
If the
date parameter includes time information, then function does not return it. However, if date includes invalid time information (e.g. "89:98"), then an error occurs.
If the
date parameter is a string that includes only numbers separated by valid date separators, then function recognizes the order for year, month and day according to the short date format you specified for your system. Function also recognizes unambiguous dates that contain month names, either in long or abbreviated form. For example, in addition to recognizing
12/30/2022 and
12/30/22, function also recognizes
December 30, 2022 and
Dec 30, 2022.
If the year part is omitted in the
date parameter, then function uses the current year from your computer's system date.
For converting
String value to
Date it is better to use the
Pm.ScanDate method.
Example:
VBScriptSelect and copy to clipboard
Dim d
d = DateValue(date)