Posted by brett on 10/03/05 00:39

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()

is there a similar function in access?

Thanks again for the help

[Back to original message]