Private Sub DateToZodiacSample()
' Print the boundaries of the Zodiac signs.
' Also serves as a sample of the DateToZodiac function.
Const dblMinDate = #1/1/96#
Const dblMaxDate = #12/31/96#
Debug.Print dblMinDate & " " & DateToZodiac(dblMinDate)
Dim varForDate As Variant
For varForDate = dblMinDate To dblMaxDate
If DateToZodiac(varForDate) <> DateToZodiac(varForDate - 1) Then
Debug.Print varForDate - 1 & " " & DateToZodiac(varForDate - 1)
Debug.Print varForDate & " " & DateToZodiac(varForDate)
End If
Next varForDate
Debug.Print dblMaxDate & " " & DateToZodiac(dblMaxDate)
End SubCopyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.