In the following query the leap year is not taken into account. 

```
 SELECT      e.id,
             e.title,
             e.birthdate
 FROM        employers e
 WHERE       DAYOFYEAR(curdate()) <= DAYOFYEAR(e.birthdate)
 AND         DAYOFYEAR(curdate()) +14 >= DAYOFYEAR(e.birthdate)

```

So in this query the birthdate of someone who is born in a leap year has got a different dayofyear in a non leap year. 

How can i adjust the query to make sure it also works in a leap year?

The mysql version i have is: 5.0.67