DateVal                                                                                                    Function

 

DATEVAL(theYear as Integer, theMonth as Integer, theDay as Integer)

 

Description

Returns a Date type by converting theYear, theMonth, and theDay inputs to Date format. Year values may be 2 or 4 digits(e.g. 95 and 1995 are equivalent.)

 

Example

Dim result as Date

Result=DateVal(1995,11,17) 'will set result to the date of 11/17/1995