You must have a datestamp field to be able to do this, the datestamp field must be updated with DATE() or DATETIME() every time the record changes in any way.

ldDate=date()-182
SELECT * FROM yourtable WHERE DATESTAMP>=ldDate

>How do I write a Select statement that will retreive the data from just the last six months.
>
>Thanks
>jim