Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_DbConnectDatabase Access Wrapper

Public Function IsValidSqlSmallDate (
v As Variant
) As Boolean

Is the date valid and does it fit into the range of the MSSQL SmallDateTime type (1 Jan 1900 to 6 Jun 2079) ? Access allows dates from the year 100 to 9999.
Attempting to insert a valid date outside this range into a back end SmallDateTime column will throw an error.

v as Variant

The date

Call Template:

Dim b As Boolean

b = xf.DbConnect.IsValidSqlSmallDate(v)

Example 1:

Debug.Print xf.DbConnect.IsValidSqlSmallDate(#1 Jan 1850#)   -> False
Debug.Print xf.DbConnect.IsValidSqlSmallDate(Null)           -> False
Debug.Print xf.DbConnect.IsValidSqlSmallDate(#1 Jan 1970)    -> True

Object Reference

Public Function IsValidSqlSmallDate (v As Variant) As Boolean

v as Variant

Call Template:

See Also:

Example 1:

Public Function IsValidSqlSmallDate (
v As Variant
) As Boolean