On 23 Apr, 22:29, macca <ptmcna...@googlemail.com> wrote:
> Yes.
>
> Ive figured it out now though thanks, i used
>
> WHERE (MONTH(dates) BETWEEN month1 AND month2)
>
> thanks anyway

But does that work when month1 is November and month2 is January?

Also you haven't included the day part?