[Resolved] date bug

[Hamsterpants]

Hi There,

I finallay got my birthday script working, well I thought I did, until I found a problem with my sql query. Basically, the query does not retrive any records where the birthdate is after 2000.

So e.g. if someone is born on 2002-03-05, nothing is returned. If I change the record so that the year is 2000, it happily retrives that record.

Here is the query:
SELECT * FROM users WHERE (DAYOFYEAR(birthday)) = DAYOFYEAR(CURDATE());

Any help would be appreciated.

Dill

[Hamsterpants]

I think the problem is something to do with Leap...o well back to the drawing board to try and figure out another solution.

Dill