Logo
Home Cart [Log In] About Us Contact Us

Object Reference

General > xf_General > DateOnlyVar (Type Testing and Conversion)

xf_GeneralGeneral Functions

Public Function DateOnlyVar (
d As Variant,
Optional DefTime As Date = #12:00:00 AM#
) As Variant

Like DateOnly(), but will accept a variant that may be Null, a Date or a String.

d as Variant

The variant date/time

Optional DefTime as Date = #12:00:00 AM#

Set this time of day as a default

Call Template:

Dim v As Variant
v = xf.Gen.DateOnlyVar(d)
v = xf.Gen.DateOnlyVar(d, DefTime)

See Also:

DateOnly

Example 1:

DateOnly(#1 Jan 1985 2:35pm#)   => #1 Jan 1985 0:00#
DateOnly(Null)                  => Null
DateOnly("1 Jan 1985 2:35pm")   => #1 Jan 1985 0:00#
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd