query - get records from a particular month - converting date and/or time from character string
after entering the following
select * from tblOrgProfile P
Inner Join tblOrgHours H on P.Agencyid = H.AgencyID
Inner Join tblOrgActivities A on A.ActivityID = H.ActivityID where H.Hours > 0 and H.Program = 'csw' and H.ActivityDate = 'May'
I get the error
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
Actvitydate is format date. How do I get all dates in the month of May