Function Dates Times Class

DateToZodiac

"Date To Zodiac Name" Returns the name of the Zodiac sign given a date.

Signature (Visual Basic / VBA)

Public Function DateToZodiac( _
    ByVal vDate As Variant _
    ) As Variant

Code Example

    DateToZodiac(#01/01/96#) = "Capricorn"
    DateToZodiac(#07/04/96#) = "Cancer"
    DateToZodiac(#11/30/96#) = "Sagittarius"

Parameters

Parameter Description
vDate The date for which the name of the Zodiac sign is returned. Function returns Null if vDate is Null or cannot be fixed up to a Date.

Notes & Version History

Note This function DOES support pre-1900 Date/time values.