/text/sbasic/shared/03030102.xhp

DateValue function DateValue Function [Runtime] Returns a date value from a date string. The date string is a complete date in a single numeric value. You can also use this serial number to determine the difference between two dates.

Syntax: DateValue [(date)] Return value: Datei66764 Parameters: Date: String expression that contains the date that you want to calculate. The date can be specified in almost any format. You can use this function to convert a date that occurs between December 1, 1582 and December 31, 9999 into a single integer value. You can then use this value to calculate the difference between two dates. If the date argument lies outside the acceptable range, $[officename] Basic returns an error message. In contrast to the DateSerial function that passes years, months, and days as separate numeric values, the DateValue function passes the date using the format "month.[,]day.[,]year". Example: Sub ExampleDateValue msgbox DateValue("12/02/1997") end sub