How do you select something within a period of time?
Like you want to select all of the order from month Jan, 2001 to month Feb, 2002?
SELECT field FROM table WHERE date BETWEEN 2001-01-01 AND 2002-02-01
Hope this helps
fLIPIS