You did not mention which database system you're using, and this is an important item of information, as all of them seem to have a different set of date functions. The <b>standard SQL </b> way of doing it is with [i]intervals[/i] -- SELECT foo FROM bar WHERE datecolumn = CURRENT_DATE - INTERVAL 1 MONTH MySQL supports this, as do several others. In Microsoft SQL Server, you have to use the proprietary GETDATE and DATEADD functions -- SELECT foo FROM bar WHERE datecolumn = DATEADD(MONTH,-1,GETDATE())

You did not mention which database system you're using, and this is an important item of information, as all of them seem to have a different set of date functions. The <b>standard SQL </b> way of doing it is with [i]intervals[/i] -- SELECT foo FROM bar WHERE datecolumn = CURRENT_DATE - INTERVAL 1 MONTH MySQL supports this, as do several others. In Microsoft SQL Server, you have to use the proprietary GETDATE and DATEADD functions -- SELECT foo FROM bar WHERE datecolumn = DATEADD(MONTH,-1,GETDATE())