Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_DbConnectDatabase Access Wrapper

Public Function DateTimeToSQLText (
d
) As String

Convert a date and time to text suitable for use in an SQL query, including date delimiters. Uses the DbConnect object's SQLStatementFormat setting to determine the correct Jet or MSSQL date delimiters

d as Variant

The date

Call Template:

Dim s As String
s = xf.DbConnect.DateTimeToSQLText(d)

See Also:

Example 1:

Dim d as Date
d = #23/2/1982 13:40 PM#
Debug.Print xf.DbConnect.DateTimeToSQLText(d)
#23 Feb 1982 13:40 PM#   (in Australia!)
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd