How Do I Query Calendar for a range of Dates?

[websissy]

Hello.

I'm trying to figure out how to use mysql to query the vbulletin calendar for all events within a range of dates (i.e. select all events from October 1 to November 30). The way vbulletin has its dates stored in the calendar, I've been unable to figure out how to do that. Can someone here please tell me how?

I know it ought to be something like:

Select * from vb_event where dateline_from > "2006-09-30" and dateline_from < "2006-12-01";

except of course, THAT query won't really work!

Thanks!