Comparison, Empty Test and Coercion Functions

Public Function ConvertToDate(d As Variant, Optional DateIfNotValid As Variant = #1/1/1970#) As Date

ConvertToDate

Public Function GetXfComparisonType(varToTest As Variant) As xf_ComparisonTypeEnum

Get the general type of a variable expressed as an xf_ComparisonTypeEnum This is used by various extension framework procedures

Public Function mt(varToTest As Variant, Optional SuppressError As Boolean = False, Optional TrimStrBeforeTest As Boolean = True) As Boolean

Is the variable empty (Null, or empty string) ?

Public Function mt_or_0(varToTest As Variant) As Boolean

Is the variable empty (Null, or empty string), 0 or "0" ?

Public Function mt_or_val(varToTest As Variant, EmptyVal As Variant) As Boolean

Is the variable empty (Null, or empty string), or the passed value ?

Public Function nze(varToTest As Variant, Optional varIfMt As Variant = Null) As Variant

Like the built in nz() function, but substitutes second value if mt() is true.

Public Function nze0(varToTest As Variant, Optional varIfMt As Variant = Null) As Variant

Like the built in nz() function, but substitutes second value if mt_or_0() is true.