ssCrazy,

Thanks for the reply, I have used

WHERE orderdate >= '31 Oct 2010'

and it has worked fine, thank you for the help 🙂 😀

Regards

Paul