Posted by Mick White on 10/03/05 02:21

brett wrote:
> 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')
>
>
>
> I tried this in access and it dosent recognize dayofyear()

where MONTH(DOB)=9
Mick

[Back to original message]