Function Dates Times Class

Zodiac

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

Signature (Visual Basic / VBA)

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

Code Example

    Zodiac(#01/01/96#) = "Capricorn"
    Zodiac(#07/04/96#) = "Cancer"
    Zodiac(#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

v2.0 Change Renamed this function from Zodiac to Zodiac.