Syntax:
CreateODBCDateTime(dateexpr)
Description:
In order to use dates in a SQL language query, the date must be formatted
properly. CreateODBCDateTime converts a BASIC datetime
type to a string of text that is valid for use in a SQL Query through
ODBC or OLEDB.
Parameter Description
dateexpr A valid data + time type or variant that can be converted to a date + time value
Example:
Sub
Main
myodbcdatetime = CreateOdbcDateTime(Now())
'is the same as
myodbcdatetime = CreateOdbcDateTime(Date()
+ Time())
End Sub
See Also: