>In VFP it's easy to reference the last month of data by using DATE()-31 but when I try this with SQL (ver. 6.5) GETDATE()-31, I get an error.
>
>How can you use MS SQL's GETDATE() and subtract (or add) a specific number of days?
Check DATEADD() function.
--sb--