Logo
Home Cart [Log In] About Us Contact Us

Object Reference

General > xf_General > DateIsEmpty (Report Filter Date and Formatting Functions)

xf_GeneralGeneral Functions

Public Function DateIsEmpty (
TestDate As Variant
) As Boolean

Check if variant Date is Null or equal to xf_JET_DATE_MIN_VALUE or xf_JET_DATE_MAX_VALUE

TestDate as Variant

Variant value to test

Call Template:

Dim b As Boolean
b = xf.Gen.DateIsEmpty(TestDate)

See Also:

DateIsEmpty
IsZeroAmt
RoundCur
RoundDbl
zn

Example 1:

DateIsEmpty(#1 Sep 1980#)        => False
DateIsEmpty(Null)                => True
DateIsEmpty(xf_JET_DATE_MIN_VALUE)   => True
DateIsEmpty(xf_JET_DATE_MAX_VALUE)   => True
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd