Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Generalxf_GeneralGeneral Functions
Public Function ConvertToDate (
d As Variant,
Optional DateIfNotValid As Variant = #1/1/1970#
) As Date
ConvertToDate
d as Variant
A variant value
Optional DateIfNotValid as Variant = #1/1/1970#
The date to use if the variant is not a valid date
Call Template:
Dim d As Date
d = xf.Gen.ConvertToDate(d)
d = xf.Gen.ConvertToDate(d, DateIfNotValid)
See Also:
Example 1:
nze(Null, #1/1/1970#) => #1/1/1970#
nze("1/1/1980") => #1/1/1980#
nze(#1/1/1990#) => #1/1/1990#
nze("notadate") => #1/1/1970#