Is is a little bit different question then what I have seen people ask here.....I have a table called Event. In the table I have a date field. I want to Select specific fields and retrive events from the begining of this month to the end of february. In other words, 3 months span.This is what I have,
SELECT EventDate, EventID, EventTitle, Event, DeptCodeFROM EventsWHERE DeptCode == '2'ORDER BY EventDate ASC
Now my question is where/how do I ask for events in 3 monts span.Please Help.