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