Signature (Visual Basic / VBA)
Public Function DateTimeToJulianDay( _
ByVal vDateTime As Variant _
) As Variant
Code Example
DateTimeToJulianDay(#1/1/1899#) = 2414655.5
DateTimeToJulianDay(#1/1/1899 9:00#) = 2414655.875
DateTimeToJulianDay(#1/1/1965#) = 2438761.5
DateTimeToJulianDay(#1/1/1965 9:00#) = 2438761.875
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
| Note | This function DOES support pre-1900 Date/time values. |