|
|
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
Navigation:
[Reply to this message]
|