Try this select a.eventid,b.name,convert(nvarchar,c.assigndate,106)as assigndate, convert(nvarchar,a.eventdate,106)as eventdate,a.event,a.details,a.eventtype from event as a left outer join emp as c on a.eventid=c.eventid left outer join user_info as b on b.userid=c.userid WHERE a.eventdate > getdate() AND ( (a.eventtype = 'Single Month' and left(convert(varchar,getdate(),102),7) = left(convert(varchar,edate,102),7)) OR (a.eventtype = 'All Month') )
Bob Ashfield Consultants Ltd