Filtering data based on date time.

Hi friends, I am trying to write script which filters data from freeradius mysql tables based on date time range. As freeradius uses rotating of mysql tables based on months, which is the best way to achieve this task? -- Thank You. Regards, Rohit Chormale 91-7416510165