calculating field showing zodiac

[vierdewereld]

Got a bit stuck on this one.

Probably easy but maybe someone can give this amateur a push in the right direction.

Trying to get the calculation together for displaying zodiac based on field "birthdate".

And this is aint the way:

Case(

Day("23") & Month("12") >= Day(birthdate) & Month(birthdate), "Steenbok",

Day("23") & Month("11") >= Day(birthdate) & Month(birthdate), "Boogschutter"

Etc..

)

Thanks in advance..

[BobWeaver]

Try:

case(Date(Month(Birthdate),Day(Birthdate),2002) >= Date(12,23,2002), "Steenbok",

Date(Month(Birthdate),Day(Birthdate),2002) >= Date(11,23,2002), "Boogschutter"

etc.

It shouldn't matter which year you use in the calculation, as long as you use the same year everywhere.

Hey! It's my birthday today. I'm finally old enough to.... to.... er, nevermind.

So, I guess I'm a Boogschutter. Cool!

[vierdewereld]

Thanks a lot, it did the trick for me!

Have a good 3424th birthday mister Bob the Mummy.

Hope you can finally get what you want.