CreateODBCDate

Syntax:

CreateODBCDate(dateexpr)

Description:
In order to use dates in a SQL language query, the date must be formatted properly. CreateODBCDate converts a BASIC date 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 type or variant that can be converted to a date

Example:

Sub Main
  CreateOdbcDate(Date())
End
Sub

 

See Also:

CreateODBCDateTime

CreateODBCTime