With MySQL you have to use MONTH(DATE) instead of datepart(). ashok ------ Ashok Hariharan http://www.unganisha.org ------