Need Expert Advice

[eluser]WanWizard[/eluser]
You can use a BETWEEN query to that falls in a certain date range.
Determine whether begin and end date are inclusive or not, to prevent overlap between two consecutive periods.