Posted by brett on 10/02/05 21:47

On 2 Oct 2005 09:54:31 -0700, "ZeldorBlat" <zeldorblat@gmail.com>
wrote:

>select clientID, FirstName, SurName, DOB
>from CLIENTS
>where DAYOFYEAR(DOB) >= DAYOFYEAR('2005-09-01')
> and DAYOFYEAR(DOB) <= DAYOFYEAR('2005-10-01')


EXCELLENT!

Works wonders, THANK YOU!

• Next in forum: Re: Birthday SQL Problem
• Prev in forum: Re: Birthday SQL Problem
• Thread view: Re: Birthday SQL Problem

[Reply to this message]