Function Dates Times Class

JulianDay

Returns the Julian Day corresponding to a date/time value. Similar to the JulianDate function, but does not correctly handle pre-1752 dates since it is based upon Microsoft's date functions.

Signature (Visual Basic / VBA)

Public Function JulianDay( _
    ByVal vDateTime As Variant _
    ) As Variant

Code Example

    JulianDay(#1/1/1899#) = 2414656
    JulianDay(#1/1/1899 9:00#) = 2414656.375
    JulianDay(#1/1/1965#) = 2438762
    JulianDay(#1/1/1965 9:00#) = 2438762.375

Parameters

Parameter Description
vDateTime The date/time value whose Julian day number is returned. Function returns Null if vDateTime is Null or cannot be fixed up to a Date.

Notes & Version History

v2.0 BugFix This function was off by .5 in previous versions of Entisoft Tools. This function has been renamed from DateTimeToJulianDay to JulianDay.