Posted by brett on 10/14/86 11:28

On Sun, 02 Oct 2005 23:21:27 GMT, Mick White
<mwhite13BOGUS@rochester.rr.com> wrote:

>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


Thanks a bunch!

Ill give that a try today.

Kind regards
brett

[Back to original message]